JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
I have a named table Summary as below
I'm trying to use conditional formatting to highlight the entire row if the date is Today but it's only highlighting the first column.
Date column
Date for Monday is entered into G14, cells below are formula as:
, etc
Day column
dragged down to E18
Conditional formatting is:
Can anyone tell why it's not highlighting the whole row from columns E:J?
TIA,
Jack
NB The column inbetween Day and Date appears empty but contains formulae masked with cell formatting: ";;;"
I have a named table Summary as below
Day | TxBCh | Date |
Monday | 22 Mar 2021 | |
Tuesday | 23 Mar 2021 | |
Wednesday | 24 Mar 2021 | |
Thursday | 25 Mar 2021 | |
Friday | 26 Mar 2021 | |
I'm trying to use conditional formatting to highlight the entire row if the date is Today but it's only highlighting the first column.
Date column
Date for Monday is entered into G14, cells below are formula as:
Excel Formula:
=G14+1, =G15+1
Day column
Excel Formula:
=Text(G14,"DDDD")
Conditional formatting is:
Can anyone tell why it's not highlighting the whole row from columns E:J?
TIA,
Jack
NB The column inbetween Day and Date appears empty but contains formulae masked with cell formatting: ";;;"
Last edited: