Need to Color Code Percentages

[chcalissie]

I've done it before and now can't remember. I tried using conditional formatting and it's not working. I want to make anything under 0% red and everything >= 0% green. Thanks for any help.

[sumansau007]

Conditional formatting will work.. Can u pl share sample excel where u want to apply this.

Sent from my GT-I9082 using Tapatalk

[FDibbins]

CF is where you would do that.

1st format all cells red, then go into CF Choose New Rule/Use Formula

=A1>=0 format fill GREEN

[chcalissie]

attendance.xlsxHere's the file with the difference calculation. I've tried conditional formatting and it's not working.

[FDibbins]

Worked fine for me
You probably did not remove the absoluting from the cell ref =E2>=0 not =$E%2>=0

[chcalissie]

thanks, but I didn't want the block colored, I wanted the numbers colored.