Windows 10: Using condition formatting, I am trying to change the colour of cell based on a date.

Discus and support Using condition formatting, I am trying to change the colour of cell based on a date. in Windows 10 Software and Apps to solve the problem; Using condition formatting, I am trying to change the colour of a cell based on a date. The idea is that if a training certificate expires in 2 months... Discussion in 'Windows 10 Software and Apps' started by Claire Hoff1, Jan 28, 2025.

  1. CLAIRE HOFF1
    Claire Hoff1 Win User

    Using condition formatting, I am trying to change the colour of cell based on a date.


    Using condition formatting, I am trying to change the colour of a cell based on a date. The idea is that if a training certificate expires in 2 months the cell will turn green.If the training certificate expires in 1 month time the cell will turn yellow.If the training certificate has expired the cell will turn red.Like a traffic light system.I am using the following formulas:=ANDC6:AY25>TODAY+30,C6:AY25<TODAY+60to turn green=ANDC6:AY25>TODAY,C6:AY25<=TODAY+30to turn yellowBut they are not working.And I can't figure out the final formula to turn t

    :)
     
    Claire Hoff1, Jan 28, 2025
    #1
  2. ALAN SH
    alan sh Win User

    How can I count the colour of cells with conditional formatting

    Yes, but that doesn't work when the cells are coloured by a conditional format statement. thanks Alan
     
    alan sh, Jan 28, 2025
    #2
  3. ALAN SH
    alan sh Win User
    How can I count the colour of cells with conditional formatting

    Someone gave me a great routine to count the colour of cells in a range. Code:
    But - that doesn't work if the colour is applied with conditional formatting. And I can't find a routine which does work for that. I thought it would be "DisplayFormat.Interior" but that doesn't work (for me). Does anyone have any idea how I can get the colour count if the colour is applied with conditional formatting? Thanks for any advice This is for the latest Excel from Office 365. Running on WIndows 10 - latest updates. Alan
     
    alan sh, Jan 28, 2025
    #3
  4. DAVEM121
    DaveM121 Win User

    Using condition formatting, I am trying to change the colour of cell based on a date.

    Conditional Formatting

    Hi J,

    I am Dave, I will help you with this.

    If you select the first revised ship date cell and select Conditional Formatting - Highlight Rules - Greater than and then click the corresponding estimated shipping date cell, that should set the conditional formatting for that cell.

    Then to apply that rule to all other cells in that column, select that cell, then click 'Format Painter' and click the cell below that cell and drag down to fill the column with the same conditional formatting rule.
     
    DaveM121, Jan 28, 2025
    #4
Thema:

Using condition formatting, I am trying to change the colour of cell based on a date.

Loading...

  1. Using condition formatting, I am trying to change the colour of cell based on a date. - Similar Threads - Using condition formatting

  2. Date Format will not change

    in Windows 10 Software and Apps
    Date Format will not change: Several Apps will not show New Zealand date format DD/MM/YYYY but shows MM/DD/YYYY, how do I change this? I have posted an image of my current settings and they look correct to me?Computer date and time is correct....

  3. Using condition formatting, I am trying to change the colour of cell based on a date.

    in Windows 10 Gaming
    Using condition formatting, I am trying to change the colour of cell based on a date.: Using condition formatting, I am trying to change the colour of a cell based on a date. The idea is that if a training certificate expires in 2 months the cell will turn green.If the training certificate expires in 1 month time the cell will turn yellow.If the training...

  4. Conditional Formatting

    in Windows 10 Gaming
    Conditional Formatting: Hello!I am trying to use excel to highlight a revised ship date. I have a column of estimated ship dates and revised ship dates. The estimated ship dates can range from any date in the week ie 5/16, 5/17 etc The revised ship date is changed manually. How can I format excel so...

  5. Conditional Formatting

    in Windows 10 Software and Apps
    Conditional Formatting: Hello!I am trying to use excel to highlight a revised ship date. I have a column of estimated ship dates and revised ship dates. The estimated ship dates can range from any date in the week ie 5/16, 5/17 etc The revised ship date is changed manually. How can I format excel so...

  6. Change Date format

    in Windows 10 Software and Apps
    Change Date format: How do I change date format from month day year to day month year? https://answers.microsoft.com/en-us/windows/forum/all/change-date-format/2e0b3c4b-67d5-42ed-9baf-da4c50520878

  7. Change Date format

    in Windows 10 Customization
    Change Date format: How do I change date format from month day year to day month year? https://answers.microsoft.com/en-us/windows/forum/all/change-date-format/2e0b3c4b-67d5-42ed-9baf-da4c50520878

  8. Formatting Cells

    in Microsoft Office and 365
    Formatting Cells: I am trying to split one cell horizontally in a word table, but when I do, all the other cells in the row double in height. How do I add an extra row in one cell without altering the overall height? Thank you 151277

  9. Conditional formating

    in Microsoft Office and 365
    Conditional formating: Hi all ,,,,again. I am using excel 2016 and have two rows of data thus,, WLWLWWLLLWL 76897665949 What I want is if the top cell is an L and the cell immediately below it is more than 8, how do I do it to change the top cell to a red fill?. PLease. Len 125425

  10. Change Date and Clock Colour

    in Windows 10 Customization
    Change Date and Clock Colour: I have been looking but up to now I have found no way to change the date and clock colour, anyone have any ideas on this ? *Smile [img] 37275