Trying to use autofill with conditional formatting with no luck.

[OodaLoop]

I'm trying to use autofill to propagate conditional formatting across several cells but I'm having no luck. It wants to lock in on the originating specific cell.

For example I want a conditional format that says:
If B2 is greater than or equal to A2 then highlight it

I then want to drag/autofill that statement to the rows below and get the following results:
If B3 is greater than or equal to A3 then highlight it
If B4 is greater than or equal to A4 then highlight it
If B5 is greater than or equal to A5 then highlight it
etc

Instead of the desired result I'm getting the following results:
If $B$2:$B$8 is greater than or equal to $A$2 then highlight it
If $B$2:$B$8 is greater than or equal to $A$2 then highlight it
If $B$2:$B$8 is greater than or equal to $A$2 then highlight it
If $B$2:$B$8 is greater than or equal to $A$2 then highlight it
etc

	A	B
1	Current Share Price	Share Price Target
2	106	105
3	15	8
4	35	32
5	1000	999
6	74	75
7	16	11
8	77	71

[Limor_OP]

Hi,

Why dont you attach it hereby in excel? It would be easier to help you...
Look at the yellow banner on the top of the page for instructions how to upload a file.

[OodaLoop]

I updated the Original Post with the attachment

[Limor_OP]

Hi,

Try:
=IF($B3>$A3,$B3)

[Limor_OP]

If you want to highlight only B then mark your range and apply this formula:

=B3<A3

[OodaLoop]

That did it! I see the problem. Don't use MS's built in formula b/c it forces the "$" . You have to write the formula yourself. Thank you!