I want to highlight a cell through conditional formatting - it depends on the
results of multiple cells. So, how could I put a formula in for conditional
formatting for the following:

inside the conditional cell there is a date 1/29/07

A3 B3 C3 D3
1/1/07 1/15/07 1/29/07 2/1/07

I want the conditional cell to highlight if any of the a3:d3 cells = 1/29/07

thanks!!

F3 is conditional formatted cell

FormulaIs:=MATCH($F$3,$A$3:$D$3,0)

"paula k" wrote:

I want to highlight a cell through conditional formatting - it depends on the
results of multiple cells. So, how could I put a formula in for conditional
formatting for the following:

inside the conditional cell there is a date 1/29/07

A3 B3 C3 D3
1/1/07 1/15/07 1/29/07 2/1/07

I want the conditional cell to highlight if any of the a3:d3 cells = 1/29/07

thanks!!

Hi Paula,

Say your conditional cell is A1 with the value 1/29/07
Then set conditional formatting for A1 with
Formula is =MATCH(A1,A3:D3,0)

HTH
Martin


"paula k" wrote in message
...
I want to highlight a cell through conditional formatting - it depends on
the
results of multiple cells. So, how could I put a formula in for
conditional
formatting for the following:

inside the conditional cell there is a date 1/29/07

A3 B3 C3 D3
1/1/07 1/15/07 1/29/07 2/1/07

I want the conditional cell to highlight if any of the a3:d3 cells =
1/29/07

thanks!!

As an added thought you can select A3 to D3 and apply
a conditional format of
Formula is =A3=$A$1
Then both cells would highlight when the match is made.

HTH
Martin






"MartinW" wrote in message
...
Hi Paula,

Say your conditional cell is A1 with the value 1/29/07
Then set conditional formatting for A1 with
Formula is =MATCH(A1,A3:D3,0)

HTH
Martin


"paula k" wrote in message
...
I want to highlight a cell through conditional formatting - it depends on
the
results of multiple cells. So, how could I put a formula in for
conditional
formatting for the following:

inside the conditional cell there is a date 1/29/07

A3 B3 C3 D3
1/1/07 1/15/07 1/29/07 2/1/07

I want the conditional cell to highlight if any of the a3:d3 cells =
1/29/07

thanks!!