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