Another Conditional Formatting Question

[BK]

Using Excel 2003.

Max helped me with an earlier conditional formatting question about coloring
an entire row when a single condition is met. Now I am trying it again in a
different worksheet and having problems.

Column A is month name
Column B is last year's price
Column C is this year's price

I want to color the entire row when this year's price is greater than last
year's price.

I selected the three columns of data and set my conditional format to:

Formula is: =C2>B2
Selected the formatting
Hit OK

Only the cells in Column A are highlighted, but they are the correct rows
(C2>B2). How can I apply the conditional formatting to all three columns.

 

[BK]

Never mind. I realize I forgot the $. It's working fine now.

 

[Bernard Liengme]

Use =$C2>$B2
this ensues the cells use the C and B rows otherwise they use relative
formulas
so column B uses D2>C2 - not what you want.
best wishes