Conditional Formatting Formula Based on Cell to Left

[Catsonheat]

Hi all,

I have a list of dates in Column C and i am trying to get Column D to highlight that row when the date equals today so that the row for today is always highlighted. I managed to get this to work using the specific cell reference but i need to use a formula which doesn't reference the cell specifically and instead references the cell to the left.

=IF(OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1)=TODAY()

I have tried using the above formula, the OFFSET returns the value of the cell to the left and i wrapped this an IF function for today but can't get it to work, any assistance would be appreciated!

Thanks in advance.

[Olly]

Use the following conditional formatting formula:

Please Login or Register  to view this content.

and apply to range $D:$D

[FDibbins]

Because TODAY() is a volatile formula, and CF can also slow your file down if used excessively, I would suggest that you put =TODAY() in it's own cell (say E1), and then reference that in the CF rule...
=$C1=$E$1

Also, avoid using full-column references in CF (see above), rather, use just the range you need, or, if that will grow, 3-4 times what you think your range would need to be.

[Pepe Le Mokko]

If you do not want to bother about the range, select it and apply the CF (=$C1=$E$1 or whatever) to the selected range - Then click - Insert - Table ( check My range has headers or not) - OK
Now each time you add a row, the CF will follow automatically

[Catsonheat]

Hi all, many thanks for your assistance, i managed to get it working using your support and solutions. Thanks all!

[FDibbins]

Happy to help