04-17-2019 08:27 PM
04-18-2019 02:02 PM
04-18-2019 04:07 PM
Hello and thanks for getting back to me.
The contents of the cells B10;Q10 are conditionally set to red with the following formula
=AND(B10 > 0,B11 = 0)
What I need to do is check if any of say row B10;Q10 are red on Sheet1. If so then I need to set the contents of a cell on another worksheet (sheet2) to red to indicate that there is an issue on the other worksheet (Sheet1).
Thanks for your help