Forum Discussion
Change cell color depending on multiple other cells
Looking to have a row turn fully green when all student submissions O through X are marked as in. How might I do this with conditional formatting?
This works for row 2, but how might I set it so it works for each row?
Select all the rows you want to apply it to, then create the rule exactly as I posted it.
Because the row number 2 does not have a $ before it, Excel will automatically adjust it to 3, 4, ... in the rows below.
Alternatively, select row 2, then click the Format Painter button on the Home tab of the ribbon, and next select the rows below.