Conditional format conundrum

[Kriptik]

I have tried to find the answer to this but nothing works. I have a target percentage in A2 and monthly attainment figures in B2, C2, D2 etc. I wanted the cells to change red if the monthly attainment exceeds the target. However even if I use an absolute ref ($A$2)...any conditional formatting always looks at the cell immediately to the left.

So if I format =IF(B2>$A$2, True,False) to colour the cells red what actualy happens is...

Jan Feb
A2=98 B2=96 C2=97

C2 changes to red because it is greater than B2

If anyone knows how I can do this without individually formatting the cells, I would be grateful

Regards

 

[Joe4]

Highlight the entire range you want to apply the formatting to (let's say B2 to Z2). Then write the formula based on the first cell in the range (the rest will adjust accordingly).

It worked for me when I wrote the Conditional Formatting Formula like this:

=B2>$A$2

 

[Kriptik]

Thank you very much