Forum Discussion
Solved
Applying Conditional Formatting Across Cells
I would very much appreciate if anyone could help me out with a conditional formatting question please. I have searched and cannot find an answer to my specific question. My question is, can condit...
Unfortunately i didn't take into account the percentage format. In the attached file you can try the updated rules according to the meanwhile provided solution.
=AND($C4>=40,$C4<=59)You can apply rules for conditional formatting according to the above rule for yellow.
OliverScheurich Thanks so much for the quick response! I can't get it work though. I have applied the formula you suggest, as follows...
…but now nothing is highlighted.
Sorry if I'm being a bit stupid. I really do appreciate your help on this!
Unfortunately i didn't take into account the percentage format. In the attached file you can try the updated rules according to the meanwhile provided solution.
- Amazing!! This works! Thank you so much OliverScheurich and SergeiBaklan. I really appreciate your help.
You have no one rule which is triggered by cell value 0.47 in C4
