Conditional Formating formula not calculating

[dshafique]

Hi guys, for some reason, in vba, i made the formula to capture data from 2 cells to the left and turn green if its greater or equal, and red if its less than. but it always shows cell E2 when i open the manage rules section.

it also gives me one wrong value for some reason. one cell is 99.93% it should be green because its greater than the value 2 to the left (99.00%) but it comes up as red. i dont know how many others might be wrong too. what could i be doing wrong in this?

 

[FDibbins]

Not sure why you need VBA for this, regular CF should do it just fine.

1 thing about CF is that if you indicate a range to apply it to, it will always show the rule applying to just the 1st cell in that range, no matter what other cell you test

What formula are you using? You will need 2 rules, =A1>+A2 format fill GREEN and =A1<A2 format fill, RED

 

[dshafique]

the reason i need vba is because i am creating a program which has dynamic data every month. we need to see the percentages, and see them pop out as there are hundreds of rows, and thousands of percents to read. my two formulas are
Cell Value >= $E2 for GREEN
Cell Value < $E2 for RED

however, even when i select row number 245, it shows E2 as the reference. I have it in a table, so I wanted match it agaisnt the data in the column [SLA target]