May 05 2022 02:28 PM - edited May 05 2022 03:35 PM
Hello,
Im trying to conditionally format cells that are greater than either values from 2 other cells:
I want to colour any of the white shaded cells in the same row that are greater than either value in the dark grey cells. As you can see some cells will not have any values.
Id like to avoid having to do two conditional format rules for each row, as there will be quite a few rows so if there is a way to use one formula for the whole block id love to learn.
(also is there a way for the formula to ignore the '<' symbol? those cells are formatted as numbers but it still causes an error)
Thanks in advance.
EDIT: Thank you both for the help. Both methods work great.
May 05 2022 02:45 PM
SolutionMay 05 2022 02:53 PM
Let's say that the range you want to format conditionally is D2:J50, with the cells in gray in C2:C50
Select D2:J50. The active cell in the selection should be in row 2.
On the Home tab of the ribbon, select 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 the formula =MIN($B2:$C2) in the box next to it. Remember, B and C are the columns shaded gray, and 2 is the row number of the active cell.
Click Format...
Activate the Fill tab.
Select a color.
Click OK, then click OK again.
May 05 2022 02:45 PM
Solution