Forum Discussion
Solved
Conditional formatting using different colours
Hi, I have a table containing children who are enrolling for instrument tuition. I have a column set to Y (Yes) is a child returned the slip from the letter, and another set to Y, when they have...
Hi Cecilia,
First, better to apply your rule not to entire column but with for some range with gap within which you data will be. Another option dynamic range or table. Otherwise it works quite slow or even hangs.
When apply 3 rules for yellow, green and red accordingly
=($F2:$F500="Y")*($G2:G500="Y") =($F2:$F500="Y")*ISBLANK($G2:G500) =ISBLANK($F2:$F500)*ISBLANK($G2:G500)*NOT(ISBLANK($B2:$B500))
again to the range with gap
=$A$2:$G$500
Please see file attached
Hi Cecilia,
First, better to apply your rule not to entire column but with for some range with gap within which you data will be. Another option dynamic range or table. Otherwise it works quite slow or even hangs.
When apply 3 rules for yellow, green and red accordingly
=($F2:$F500="Y")*($G2:G500="Y") =($F2:$F500="Y")*ISBLANK($G2:G500) =ISBLANK($F2:$F500)*ISBLANK($G2:G500)*NOT(ISBLANK($B2:$B500))
again to the range with gap
=$A$2:$G$500
Please see file attached
Thank you so much Sergei! You have helped enormously. Much appreciated.