Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Change cell color depending on multiple other cells

Copper Contributor

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?

Capture.PNG

3 Replies

@Cannalou 

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.

This works for row 2, but how might I set it so it works for each row?

@Cannalou 

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.