Seahorse
Member
Essentially I have a monster spreadsheet that need to do one of thre things.
Highlight 3 columns in Red if Actual date is greater than Target. This works in the attached.
Highlight 3 columns in Green If target matches actual. This doesn't work?
No highlighting if not any of the above.
One further issue is that "Applies to" selection box will not let me remove the absolute $ against the Row number, if the spreadsheet grow this means I have to change the value, something I would rather not do.
It is not clear to me why the rules are not applying as intended? or whether I need an ISBLANK first with "Stop if True" as what I thought should be the easy part is not playing nice.
Highlight 3 columns in Red if Actual date is greater than Target. This works in the attached.
Highlight 3 columns in Green If target matches actual. This doesn't work?
No highlighting if not any of the above.
One further issue is that "Applies to" selection box will not let me remove the absolute $ against the Row number, if the spreadsheet grow this means I have to change the value, something I would rather not do.
It is not clear to me why the rules are not applying as intended? or whether I need an ISBLANK first with "Stop if True" as what I thought should be the easy part is not playing nice.