Forum Discussion
Colour condition using IFS function
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
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
