Conditional formatting columns

  • Thread starter Thread starter DRKENNE
  • Start date Start date
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?
 
Select entire column. Then do Format-Conditional format, formula is:
=P1>O1
Select desired formatting pattern, hit 'ok'.
 
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!*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top