Hi all! Good day. I would like to seek for help. How can I simplify my formula,
=OR($K$49:$K$58="SUN",$N$49:$N$58="SUN",$Q$49:$Q$58="SUN",$T$49:$T$58="SUN",$W$49:$W$58="SUN",$Z$49:$Z$58="SUN",$AC$49:$AC$58="SUN",$AF$49:$AF$58="SUN",$AI$49:$AI$58="SUN",)
This formula is used as conditional formatting formula of cells A49:AI58. Those given cells are the ones that might have the value SUN. If any of those cells has the value, the range cells will change its color.
I hope you can help me with this. Thanks a lot!
=OR($K$49:$K$58="SUN",$N$49:$N$58="SUN",$Q$49:$Q$58="SUN",$T$49:$T$58="SUN",$W$49:$W$58="SUN",$Z$49:$Z$58="SUN",$AC$49:$AC$58="SUN",$AF$49:$AF$58="SUN",$AI$49:$AI$58="SUN",)
This formula is used as conditional formatting formula of cells A49:AI58. Those given cells are the ones that might have the value SUN. If any of those cells has the value, the range cells will change its color.
I hope you can help me with this. Thanks a lot!