Oct 12 2023 07:59 AM
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?
Oct 12 2023 08:02 AM
Select rows 2 to the last used row.
The active cell in the selection should be in row 2.
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
=AND($O2:$X2="x")
Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.
Oct 12 2023 08:39 AM
Oct 12 2023 09:01 AM
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.