Excel/Conditional Formatting 1

[robertbarrett]

Goal: If the date typed in B3 is older than 25 days, I would like to highlight the entire row in red, UNLESS M3 contains any value whatsoever.


Any tips on how to do this? I have already created a column that gives "days old" using "=IF(ISBLANK(B3), "", TODAY()-$B3)"

Any help is appreciated

 

[SkipVought]

Hi,

=AND(ISBLANK($M3),TODAY()-$B3>25)

Maybe you’ll need to add NOT(ISBLANK($B3)) too.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}