- Joined
- May 10, 2006
- Messages
- 10,500
- Location
- Preston, Lancs
- Car
- S204 C220CDi Sport ED125 (Mr) Kia Picanto Domino 1.1 (Mrs)
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 would be appreciated
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 would be appreciated

Last edited: