Forum Discussion
Conditional formatting x amount of cells based off of 1 other cell
Hello all, I am trying to get multiple cells highlighted based off of 1 number. For example, if i have the number 10 in A1, i would like A2-A12 to be highlighted a certain color. I would also like ...
Select A2:A12.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=A$1>=1
Click Format...
Activate the Fill tab.
Select red.
Click OK, then click OK again.
Repeat these steps, but with the formula =A$1>4 and yellow.
Repeat them again with the formula =A$1>8 and green.