Conditional Formatting Columns

Closed
vschu Posts 1 Registration date Thursday November 15, 2018 Status Member Last seen November 15, 2018 - Nov 15, 2018 at 09:32 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 15, 2018 at 11:25 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Nov 15, 2018 at 11:25 AM
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
0