Forum Discussion
Solved
Color fill whole row based on text in certain column
I'm making an assignment tracker for my classes. I want the row to fill a certain color based on the class number (in column i). I've followed videos that show conditional formatting equations to do ...
Select rows 2 to 100, or if you prefer A2:K100. The active cell in the selection should be in row 2, for example A2.
Use the following formula in the conditional formatting rule:
=$I2=315
(neither single nor double quotes around 315)
Select rows 2 to 100, or if you prefer A2:K100. The active cell in the selection should be in row 2, for example A2.
Use the following formula in the conditional formatting rule:
=$I2=315
(neither single nor double quotes around 315)
This worked thank you!