multiple cells conditional formatting
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!!
|