Hi All,
I'm experimenting with the following formula
H15 contains the current time using
H17 and I17 contain two times.
The first formula gives me a yes/no depending on if the current time is between the two specified times.
If I want to then highlight the cell RED using conditional formatting if the answer is YES, how do I do that?
Basically I'm not sure how to transfer the logic of the formula I've used to something Conditional Formatting can understand correctly.
I've tried removing the IF and the AND in various combinations but it doesn't seem to work.
I'm sure the solution is simple, but Conditional Formatting has always been my weakness I'm afraid
Thanks!
I'm experimenting with the following formula
Excel Formula:
=IF(AND(H15>H17,H15<I17),"YES","NO")
H15 contains the current time using
Excel Formula:
=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))
H17 and I17 contain two times.
The first formula gives me a yes/no depending on if the current time is between the two specified times.
If I want to then highlight the cell RED using conditional formatting if the answer is YES, how do I do that?
Basically I'm not sure how to transfer the logic of the formula I've used to something Conditional Formatting can understand correctly.
I've tried removing the IF and the AND in various combinations but it doesn't seem to work.
I'm sure the solution is simple, but Conditional Formatting has always been my weakness I'm afraid
Thanks!