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...