Any experts out there?
I want to change the fill colour (to custom colour RGB 5,255.5) of cell range A1-A10 if the contents of cell A9 is the word 'Green'.
I'm almost there but can't quite get it. I know how to change the cell that the word is in using Conditional Formatting.
The formula...