S
Sebastian Kinnaird
Is it possible to create a formula that outputs a different result depending
on the background color used by a particular cell?
Something along the lines of:-
=IF(AND(A1="Test",COLOR=RED)=TRUE,"Test true","Test false")
So it would only return a true result if the contents of A1 said the word
Test as well as having a background color of red.
Any advice would be greatly appreciated.
Regards,
Seb
on the background color used by a particular cell?
Something along the lines of:-
=IF(AND(A1="Test",COLOR=RED)=TRUE,"Test true","Test false")
So it would only return a true result if the contents of A1 said the word
Test as well as having a background color of red.
Any advice would be greatly appreciated.
Regards,
Seb