Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional formatting based on % of another column

 I need the EAC column to change colors (stoplight) as follows: green=EAC is 90% or less of the Approved Budget yellow=EAC is 100% or less of the Approved Budget red=EAC is 100% or greater o...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Okay, so I finally figured it out.  I changed the percentages to 'number' on the dropdown and added the decimal.  That, in it's self still wasn't working correctly.  I discovered that you were partially correct in that, but not 100%.  What works (the way I need it to) is to change the first value ("is" statement) to percent.  Now, the icons are the correct color according to my needs.  I appreciate your help in getting me there!

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Okay, so I finally figured it out.  I changed the percentages to 'number' on the dropdown and added the decimal.  That, in it's self still wasn't working correctly.  I discovered that you were partially correct in that, but not 100%.  What works (the way I need it to) is to change the first value ("is" statement) to percent.  Now, the icons are the correct color according to my needs.  I appreciate your help in getting me there!