Select H5:H12 in 2nd sheet and then go to conditional formatting. Erase everything there and use this one
=AND(NOT($E5=""),$F5-60<TODAY())
WB is also attached
Is that what you're looking for???..
HTH
Select H5:H12 in 2nd sheet and then go to conditional formatting. Erase everything there and use this one
=AND(NOT($E5=""),$F5-60<TODAY())
WB is also attached
Is that what you're looking for???..
HTH
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks