Colour condition using IFS function

New Contributor



is it possible to use colour as a condition when using the IFS function?


If is possible, how to define the colour? 


Thank you 

Jan Vacir

2 Replies


No, that is not possible.

If the cells have been colored using conditional formatting, you can use the conditions from the conditional formatting rule(s) instead of using the colors.

Otherwise, you'd need VBA.

Thank you, eventhought it is not the answer I was hoping for