Forum Discussion
vacirjan
Jan 30, 2023Copper Contributor
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
HansVogelaar
Jan 30, 2023MVP
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.
- vacirjanJan 30, 2023Copper ContributorThank you, eventhought it is not the answer I was hoping for