Conditional Formating Based on the difference of dates

  • Thread starter Thread starter Billy J. McDuffie
  • Start date Start date
B

Billy J. McDuffie

1. I am trying to change the color of a date to red whenever the date in a
cell is greater than or equal to 90 days olds when compare to todays date.

2. Likewise, I need to be able to change a row color when a date is within
90 of reaching the current date.
 
You can use Format, Conditional formatting with 2 conditions.

1st condition : Cell value is; Greater than or equal to; =TODAY()+90
press the format button and choose the font tab and choose colour of
text (RED)

2nd condition : Cell value is; between; =TODAY()-90; =TODAY()
press the format button and choose the patterns tab and choose colour
of fill.

Hope this is what you wanted.
Mike
 
Billy J. McDuffie said:
1. I am trying to change the color of a date to red whenever the date in a
cell is greater than or equal to 90 days olds when compare to todays date.

2. Likewise, I need to be able to change a row color when a date is within
90 of reaching the current date.
Click to expand...

1. Go to Conditional fomatting and put "formula is" =TODAY()-$B$4>90
then select your format

2. put "formula is" =TODAY()-B$4<90 then select Patern format
color. Then use the Format Brush to copy the format to all the cells
in that row. ed
 
Back
Top