Conditional formatting columns

D

DRKENNE

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?
 
L

Luke M

Select entire column. Then do Format-Conditional format, formula is:
=P1>O1
Select desired formatting pattern, hit 'ok'.
 
D

DRKENNE

Seemed to work so far. Thanks

Luke M said:
Select entire column. Then do Format-Conditional format, formula is:
=P1>O1
Select desired formatting pattern, hit 'ok'.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
 
Top