Hi,
I am trying to get cell AC6 on Sheet2 to change to a colour (any colour for now) depending on what info is in cell G6 Sheet2.
If G6 has a £ sign in it then I would like AC6 to automatically change to a colour. If G6 has anything other than a £ sign AC6 can just stay blank without a colour.
I really appreciate any help, please see the spreadsheet I have uploaded. Thanks.
Bookmarks