Conditional Formating Based on the difference of dates

[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.

 

[Freemini]

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

 

[ed]

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.

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