Conditional Formatting
 

I have 2 columns of prices and I need to highlight if one is higher in every
row.

Example , if Cell A1 is higher than Cell B1, turn it red.

My problem is that I want this rule applied to every row, and it only seems
to be alble to refer to the original reference, rather than to apply the row
to each adjacent cell. So I want to compare the prices in Cell A25 with B25
- how can I accomplish this without having to manually change the cell
reference for in every row. I have tried the copy-paste-special-formula and
the hightlight cell-hit paint brush then drag through the cells I want. It
will only retain that first reference.

Boy, I hope this is making sense.

Select Cell A1, Conditional Formula is =IF(A1B1,1,0)
Select Cell B1, Conditional Formula is =IF(B1A1,1,0)

Copy both cells and Paste Special Formats on all the rest

I am not sure what you want to do when A1=B1, thus it will not
highlight anything. But I am sure you can handle that.


Hope this helps.




Sistereinstein Wrote:
I have 2 columns of prices and I need to highlight if one is higher in
every
row.

Example , if Cell A1 is higher than Cell B1, turn it red.

My problem is that I want this rule applied to every row, and it only
seems
to be alble to refer to the original reference, rather than to apply
the row
to each adjacent cell. So I want to compare the prices in Cell A25
with B25
- how can I accomplish this without having to manually change the cell
reference for in every row. I have tried the copy-paste-special-formula
and
the hightlight cell-hit paint brush then drag through the cells I want.
It
will only retain that first reference.

Boy, I hope this is making sense.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390779