Conditional Formatting

[lou]

I am new to excel 2007 and I can't get it to work the conditional
formatting to work the same way as in 2003. If I have a date in cell
"A1" for example and I have a bunch of dates from C2 to C1000, how can
I get the cells with the C2:C1000 range to highlight if they are
greater than A1. I can get it to work 1 at a time but it doesn't seem
to work when I try to set this condition all at once for the entire
range.

Thanks

 

[Pete_UK]

I think Excel might be trying to convert your formula to absolute cell
references (or maybe you got them mixed up). You need to highlight the
cells C2 to C1000, then pull up the CF dialogue box. Choose Formula Is
and enter this formula:

=C2>A$1

assuming that C2 is the active cell in the selected range. Click the
Format button, set the format and OK your way out.

Hope this helps.

Pete

 

[T. Valko]

Try this...

Clear all the conditional formatting that you have tried for this range.

Select the *entire* range C2:C1000 starting from cell C2. C2 will be the
active cell. The active cell is the one cell in the selected range that is
not shaded. The formula used is relative to the active cell.

Goto 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:
=C2>A$1
Click the Format button
Select the desired style(s)
OK out