Menu
Ask a question Report

Conditional Formatting Columns

Posts
1
Registration date
Thursday November 15, 2018
Last seen
November 15, 2018
 - - Latest reply: TrowaD
Posts
2435
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 4, 2018
 - Nov 15, 2018 at 11:25 AM
Office Software Ask a question Report
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!

See more 

Your reply

Reply to this topic

1 reply

Report Respond to TrowaD
Posts
2435
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 4, 2018
0
Thank you
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
Respond to TrowaD

Your reply

Reply to this topic
Ask a question