I am working on building a weight loss calculator. I am having problems using conditional formatting in my spread sheet. I am trying to have it green if less than c2, and red if greater than c2 . c2 is performed via a v look up function. I have also tried custom function to no avail. Ideally I would like to break this down as a percentage of c2 and have yellow as well but 1 step at a time. I have tried converting to a value and an int and still it's not working correctly. Thank you in advance!
CodePudding user response：
Please try the following
- Select
Custom formula is - Put
=F15<C$2
Repeat once more with =F15>C$2
To avoid formatting empty cells use =AND(G14<F$3,G14<>"")