Conditional Formatting

hemrajrav328
NewLounger
Posts: 19
Joined: 30 Aug 2023, 20:25

Conditional Formatting

Post by hemrajrav328 »

Can a conditional formatting be applied to the values in B:BI to highlight values greater than the values in BK ?
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78370
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional Formatting

Post by HansV »

Select B3:BI15.
B3 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop-down set to 'Cell Value'.
Select 'greater than' from the second drop-down.
Enter =$KB3 in the box next to it.
Click Format...
Specify the desired formatting in the Fill tab or Font tab.
Click OK, then click OK again.

S0006.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans