Conditional Formatting Based on Today Function

**Madball** · 01-18-2012, 10:15 AM

Hello,

I am posting today to find out if there is anyone here that may know how to create conditional formatting based on the TODAY() function. basically I want along ROW1 of my excel spreadsheet a list of dates, so for example A1 to A10 will be shown like this 01/01/2012, 02/01/2012, 03/01/2012 etc... Then on ROW2 within the same range it will have the formula =TEXT(cell above,"DDD").

Now using conditional formatting when the date in ROW1 equals present day it will change the background colour of the cell to a different colour and in addition also change the colour of the cell below to the same colour. I've been trying this for a bit now and I can't get my head around it.

I have also created an excel workbook that I have attached to this post.

**Richard Buttrey** · 01-18-2012, 10:24 AM

Hi,

See attached.

Incidentally did you realise that you could just format row 1 as "ddd" to show the three letter day?

**Madball** · 01-18-2012, 10:37 AM

Perfect! Thank you very much, I can see where I went wrong. I had selected the area I want to format but also selected the entire area to change when the value is true rather than individual coloumns. Also thank you for the tip regarding changing the format of the date so I don't need to have two rows.