View Single Post
 
Old 07-14-2023, 09:14 AM
whsnow whsnow is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Mar 2018
Posts: 7
whsnow is on a distinguished road
Default IF statement in Conditional Formatting

I have successfully added the following formula to create "warning flags" in cells to indicate time left to an application deadline:

=$A2-TODAY()>90
=AND($A2-TODAY()>=61, $A2-TODAY()<=90)
=AND($A2-TODAY()>=31, $A2-TODAY()<=60)
=AND($A2-TODAY()>=0, $A2-TODAY()<=30)

Respectively colored Green, Yellow, Orange, and Red.

Another column (say D) is used to enter the date the application was received.

I would like to include (what I am assuming is) an IF statement that would override the initial instructions and color the cell in Column A Blue IF there is a date entered in the same row in Column D.

Thanks.
Reply With Quote