...say the current time is 930am, so the cells that have a time BEFORE 9:30am yesterday should turn red. The cells that have a time AFTER 9:30am yesterday should remain unaffected.
There is thea setting to choose so, right from within the conditional format menu.
For your chosen range you pick the
setting Is between and as values =NOW()-2 and =NOW()-1
...say the current time is 930am, so the cells that have a time BEFORE 9:30am yesterday should turn red. The cells that have a time AFTER 9:30am yesterday should remain unaffected.
There is the setting to choose so right from within the conditional format menu.
...say the current time is 930am, so the cells that have a time BEFORE 9:30am yesterday should turn red. The cells that have a time AFTER 9:30am yesterday should remain unaffected.
There is a setting to choose so, right from within the conditional format menu.
For your chosen range you pick the
setting Is between and as values =NOW()-2 and =NOW()-1
...say the current time is 930am, so the cells that have a time BEFORE 9:30am yesterday should turn red. The cells that have a time AFTER 9:30am yesterday should remain unaffected.
There is the setting to choose so right from within the conditional format menu.
