Colour condition using IFS function

New Contributor

Hello, 

 

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

@vacirjan 

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