Conditional Formatting Columns [Closed]

Report
Posts
1
Registration date
Thursday November 15, 2018
Status
Member
Last seen
November 15, 2018
-
Posts
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
-
Hello,

I would like to know if there is a way to conditionally format a column. I want cells in column C to highlight if they are higher than the values in Column B. However, the values in column B differ in each row. Is there a way to condition one cell in column C and drag it down so I don't have to condition each cell?

Ex:

B C
15 14
20 26.58
15 21.01
25 24.89

Thanks!

1 reply

Posts
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
466
Hi Vschu,

Select column C, goto conditional formatting and choose new rule.
Select the second option: Format only cell that contain.
1st dropdown: Cell value
2nd dropdown: Greater then
3rd field: B1
Choose format
Click OK

No need to drag it down.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!