B
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.
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.