Forum Discussion
Excel Conditional Formatting Challenge
Select C4 to the end of the data. C4 should be the active cell in the selection.
(We don't select column B since a score in column B does not have a predecessor)
On the home tab of the ribbon. select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cell to format'.
Enter the formula
=AND(C4<>"",C4<>"a",C4>LOOKUP(1000,$B4:B4))
Click Format...
Activate the Fill tab.
Select green.
Click OK, then click OK again.
Repeat the above steps, but with the formula
=AND(C4<>"",C4<>"a",C4=LOOKUP(1000,$B4:B4))
and yellow as color.
Finally, repeat them again with
=AND(C4<>"",C4<>"a",C4<LOOKUP(1000,$B4:B4))
and red as color.
Select C4 to the end of the data. C4 should be the active cell in the selection.
(We don't select column B since a score in column B does not have a predecessor)
On the home tab of the ribbon. select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cell to format'.
Enter the formula
=AND(C4<>"",C4<>"a",C4>LOOKUP(1000,$B4:B4))
Click Format...
Activate the Fill tab.
Select green.
Click OK, then click OK again.
Repeat the above steps, but with the formula
=AND(C4<>"",C4<>"a",C4=LOOKUP(1000,$B4:B4))
and yellow as color.
Finally, repeat them again with
=AND(C4<>"",C4<>"a",C4<LOOKUP(1000,$B4:B4))
and red as color.
HansVogelaar
Cheers, worked perfectly 🙂
