#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
You've already asked this here:
https://www.msofficeforums.com/excel...two-cells.html I responded with a question or two but you haven't answered… |
#3
|
||||
|
||||
Thanks for pointing that out p45cal, I was wondering when the OP would notice our answers...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Statement using data columns | NLJ | Excel | 7 | 03-21-2022 03:06 PM |
Conditional formatting using specified range instead of With Selection statement | slouw | Excel Programming | 3 | 01-26-2019 06:24 AM |
Conditional Formatting/If Statement with Dates | AndrewEnos | Excel | 2 | 07-22-2014 07:34 AM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |