I am creating a spreadsheet with Dependant Lists to allow the end user to select options and make the process simple.
There is a need for a cell called "Other" (Currently G3) which I want to fill in grey based on two different scenarios.
Scenario 1. If F3 doesn't equal "Other" then color grey (Solved using =$F3<>"Other") in the conditional formatting box.
Scenario 2. If E3 EQUALS "Other" then fill white. This is the equation I am stuck on as $G3="Other" fails.
Does anyone know what code I should be using instead?
There is a need for a cell called "Other" (Currently G3) which I want to fill in grey based on two different scenarios.
Scenario 1. If F3 doesn't equal "Other" then color grey (Solved using =$F3<>"Other") in the conditional formatting box.
Scenario 2. If E3 EQUALS "Other" then fill white. This is the equation I am stuck on as $G3="Other" fails.
Does anyone know what code I should be using instead?