Helpful Mumsnetters have helped me before with your wizardry skills so I'm hoping you'll strike again - however, I'm not sure this is possible in Google Sheets (we don't use Excel anymore).
- I have two separate Google Sheets (sheet A and sheet B for the purpose of the example)
- If a specific cell value in sheet A changes to "complete", I want a specific cell in sheet B to change to the colour red
Can this be done?