Conditional Formating

C

carl

I would like to use the conditional formating to compare the values in col
C,D,E, with the value in col B. If the value in col C,D,E is less than the
value on col B, highlight the appropriate col.

ColA ColB ColC ColD ColE
5-Jul 7.33% 12.08% 15.17% 13.62%
6-Jul 7.47% 10.71% 13.21% 7.69%
7-Jul 8.82% 11.55% 7.09% 7.96%
8-Jul 8.64% 14.56% 6.36% 7.34%

For example, in this table, in 7-Jul row, cell D and E would be highlighted.

Thank you in advance.
 
D

Dave Peterson

Select your range (C2:E????)

And with C2 the activecell:
format|conditional formatting
"Cell value is"
Less than
=$B2

Give it a nice format.
 

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

Similar Threads


Top