Conditional Formatting

[CJG19]

Good Morning All,

I am trying to do some conditional formatting and getting really frustrated, I wonder if you can help?

If MC has had for more than 7 days and RL column is blank then highlight the cell in the MC column, if there is a date or an N/A then do not highlight.
If RL has had for more than 7 days and MDu column is blank then highlight the cell in the RL column, if there is a date or an N/A then do not highlight.
If MDu has had for more than 7 days and Assts Rec is blank then highlight the cell in the MDu column.

TIA!

CJG19

 

[offthelip]

The way I would do that is with a number of "helper" columns that do the logic , the columns can way off to the right so the user doesn't see them. Then it makes the conditional formattting easy.

 

[Candyman8019]

Give something like this a try where you have a couple of pre-conditions and 'stop if true' is checked.

The formula for the highlight would be something along the line of: =AND(TODAY()-A2>=7, ISBLANK(B2)=TRUE)

Once you have this working, you can apply the formatting to other cells.

 

[CJG19]

It works perfectly, thanks ever so much Candyman8019!