Conditional Formatting
-
hemrajrav328
- NewLounger
- Posts: 19
- Joined: 30 Aug 2023, 20:25
Conditional Formatting
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.
-
HansV
- Administrator
- Posts: 78523
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional Formatting
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.
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.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans