talkinggoat
New Member
- Joined
- Feb 1, 2022
- Messages
- 36
- Office Version
- 365
- Platform
- Windows
I have a table with a cell ($I$4) that has =today() and a time range 8-17 on row 5.
The conditional formatting formula that's not working is:
and I have selected the range of where it's supposed to be applied.
I can use INDIRECT(ADDRESS(5, COLUMN())) = HOUR(NOW())) by itself, and it will highlight every column with the value of whatever the time is, within the selected range.
I can paste =AND(TODAY() = $I$4, INDIRECT(ADDRESS(5, COLUMN())) = HOUR(NOW())) into a cell, by itself, and it will be true. If I move over one cell, into another time, it's false.
If I paste the entire formula into conditional formatting, nothing happens. What am I doing wrong?
The conditional formatting formula that's not working is:
Excel Formula:
=AND(TODAY() = $I$4, INDIRECT(ADDRESS(5, COLUMN())) = HOUR(NOW()))
I can use INDIRECT(ADDRESS(5, COLUMN())) = HOUR(NOW())) by itself, and it will highlight every column with the value of whatever the time is, within the selected range.
I can paste =AND(TODAY() = $I$4, INDIRECT(ADDRESS(5, COLUMN())) = HOUR(NOW())) into a cell, by itself, and it will be true. If I move over one cell, into another time, it's false.
If I paste the entire formula into conditional formatting, nothing happens. What am I doing wrong?