Forum Discussion

AmberJane's avatar
AmberJane
Icon for Helper III rankHelper III
2 years ago
Solved

Conditional Formatting Help Pls!! Why are these cells not highlighting.

I am not sure if this is because its a calculated measure but I cannot get this to work. Please see 2 examples below.       
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    AmberJane you should change percent to number and keep the value 1

parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

AmberJane you have to use .99 and 1, it is a % measure so 1 is 100%

  • AmberJane's avatar
    AmberJane
    Icon for Helper III rankHelper III
    2 years ago

    Now I can't get it to highlight at all using the examples I provided above and then also using your suggestion 😞