Jan 30 2023 03:26 AM - edited Jan 30 2023 03:27 AM
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
Jan 30 2023 04:22 AM
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.
Jan 30 2023 06:59 AM