Hi,
I am looking to put some conditional formatting on dates however need some IF statements somewhere.
Further explained in the example spreadsheet.
Example3.xlsx
Cheers
Hi,
I am looking to put some conditional formatting on dates however need some IF statements somewhere.
Further explained in the example spreadsheet.
Example3.xlsx
Cheers
Please confirm which column cell needs to be highlighted?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Like this ?
use the following three conditions
red
=AND(P4="",TODAY()+21>J4)
amber
=AND(P4="",TODAY()+42>J4)
green
=AND(P4="",TODAY()+42<J4)
in that order and use stop if true
see attached
This is great. Thanks both
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks