Conditional Formatting

  • Thread starter Thread starter MDKimzey
  • Start date Start date
M

MDKimzey

Is it possible to apply a conditional formatting in cases where each value in
column P exceeds the adjacent value in column D.

I have several hundred rows and would like to do this without visiting each
individual cell in column P.
 
Apply it to one cell, then select the entire column or just the cells you
want. Make sure the first cell is part of the selection. Go to the
Conditional Formatting menu and it should display the custom format from
that first cell. Click OK and it will apply it to the selected cells.

Or, copy/paste formats.
 
Where in the Conditional Formatting menu should I see the custom formatting
applied to the first cell? I wonder if this feature was left out of Excel
2007.
 
Looks like conditional formatting is drastically modified in 2007. Add to
the "Applies To" range reference.
 
Yes.

Select your range of cells in P, with P2 active, then
CF/ Cell Value Is/ Greater Than/ =D2
and Format as appropriate.

Otherwise apply the format to P2 and use Format Paint to copy down
Or, as a third optionn, Copy from P2 and Paste Special/ Format
 
Back
Top