Forum Discussion

lesliannd2's avatar
lesliannd2
Copper Contributor
May 18, 2017

Conditional Formatting Not Working

I am trying to use conditional formatting and it is not working properly. I need the cells that are 74 or below to show a red icon and 75 and above showing a green icon. I am still getting red icons ...
excel
lesliannd2's avatar
lesliannd2
Copper Contributor
May 19, 2017

I literally can not get it. I have been working on it for 3 days now and it's driving me crazy. :( Any help would be greatly appreciated the 75% is still staying Red.

 

I need 74 or below in RED

I need 75 or above in GREEN  

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 19, 2017

    I guess you need in green not above 75, but above 75%. Other words above 0.75

     

    • lesliannd2's avatar
      lesliannd2
      Copper Contributor
      May 19, 2017

      It worked perfectly! Thank you! Thank you! Thank you! I appreciateyour help!