SOLVED

Conditional Formatting Formula Help

Copper Contributor

I want to know if it is possible to create a rule for a cell color to change when another cell contains a specific text.


For example: Cell G6 has the text "Sold & Installed" and cell W6 is empty, I want to have the cell W6 to be highlighted to show that there is supposed to be a value in cell W6 because cell G6 has that text "Sold & Installed". This is all to highlight that the Cell is supposed to have a value but does not.

If anyone has any answers or suggestions, it would be greatly appreciated.

4 Replies
best response confirmed by Mocha365 (Copper Contributor)
Solution

Select W6 (or a range in column W starting in W6).

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(G6="Sold & Installed", W6="")

 

Click Format...
Activate the Fill tab.
Select red as highlight color.
Click OK, then click OK again.

I see the formula works on Excel the application, but I also need to apply this same formula to Excel on Microsoft 365 One Drive. The option 'Use a formula to determine which cells to format' does not appear when creating a new rule, so is there another way to make this work?

I think you'll have to create the rule in the desktop version of Excel. Hopefully it will still work in the browser version, but you cannot create or modify it there.

Sadly the Formula does not transfer over. But I will see if there is another way.

1 best response

Accepted Solutions
best response confirmed by Mocha365 (Copper Contributor)
Solution

Select W6 (or a range in column W starting in W6).

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(G6="Sold & Installed", W6="")

 

Click Format...
Activate the Fill tab.
Select red as highlight color.
Click OK, then click OK again.

View solution in original post