Conditional Farmatting to another cell by todays date

[splottoman]

Hi,

I am working on a spreadsheet that has dates running across the headers and peoples names along the rows.

What I am after is to format a cell to highlight green if the column it is in is todays date.

I know to go into conditional formatting and select 'Use a formula to determine which cells to format' but I cannot get it to work to todays date.

Thanks in advance.
Steve

[AliGW]

Try this:

=A2=TODAY()

where A2 is the first cell in the range of dates.

In the APPLIES TO field, type your range, e.g.:

=$B$2:$B$200

The cells in B will go green if the corresponding cell in A is today's date.

[Tony Valko]

Let's assume the range of dates is B1:F1

Select the ENTIRE range B1:F1 starting from cell B1.
Cell B1 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=B1=TODAY()

Click the Format button
Select the desired style(s)
OK out

[splottoman]

Hi
Thanks for your quick response!

[AliGW]

Thanks for the rep!