Forum Discussion
Solved
Conditional Formatting Formula Help
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.
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.
4 Replies
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.
