Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |