![]() |
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? |
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? |
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? |
All times are GMT +1. The time now is 02:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com