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.

--
Tim Zych
www.higherdata.com
Compare data in workbooks and find differences with Workbook Compare
A free, powerful, flexible Excel utility

"MDKimzey" wrote in message
...
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.

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.

"Tim Zych" wrote:

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.

--
Tim Zych
www.higherdata.com
Compare data in workbooks and find differences with Workbook Compare
A free, powerful, flexible Excel utility

"MDKimzey" wrote in message
...
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.

Looks like conditional formatting is drastically modified in 2007. Add to
the "Applies To" range reference.

--
Tim Zych
www.higherdata.com
Compare data in workbooks and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"MDKimzey" wrote in message
...
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.

"Tim Zych" wrote:

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.

--
Tim Zych
www.higherdata.com
Compare data in workbooks and find differences with Workbook Compare
A free, powerful, flexible Excel utility

"MDKimzey" wrote in message
...
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.

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
--
David Biddulph

"MDKimzey" wrote in message
...
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.