| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting columns
I'd like to add a color to all cells in one column (P) where the value in
that cell exceeds the value in another column (o). Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting columns
Select entire column. Then do Format-Conditional format, formula is:
=P1O1 Select desired formatting pattern, hit 'ok'. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "DRKENNE" wrote: I'd like to add a color to all cells in one column (P) where the value in that cell exceeds the value in another column (o). Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting columns
Seemed to work so far. Thanks
"Luke M" wrote: Select entire column. Then do Format-Conditional format, formula is: =P1O1 Select desired formatting pattern, hit 'ok'. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "DRKENNE" wrote: I'd like to add a color to all cells in one column (P) where the value in that cell exceeds the value in another column (o). Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - 2 columns | Excel Worksheet Functions | |||
| conditional formatting- same value, different columns | Excel Discussion (Misc queries) | |||
| conditional formatting for key-value columns | New Users to Excel | |||
| Conditional Formatting-Comparing Two Columns | Excel Discussion (Misc queries) | |||
| Conditional Formatting 4 Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
