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
Bookmarks