I need the IF statement that asks if a cell colour is equal to red.
ie. If the background colour of cell A1 is red then return a 1, otherwise return a 0.
Is this possible?
Or even more ideal would be a cell formula that returns a '1' if the background colour of ANY cell on the worksheet is red. But this would be too perfect!
Thankyou to anyone that can help here!