conditional formatting

  • Thread starter Thread starter Charles Eaves
  • Start date Start date
C

Charles Eaves

can excel 2007 do this in conditional formating?
A B Group Total
Bathtubs & Acc. 90325 4
Say, when you do a conditional format < 10 to the column labeled "total"
and I have it do a green fill.
I would like the cells ( Bathtubs & Acc.,90325 and 4) to be highlighted in
green.
I have tried but 90325 never get highlighted because it is greater than 10.
Is it possible?
Thanks
 
Hi Charles,

I'm not sure how the headers A, B, Group & Total relate to only 3 lots of
data below them.

Anyway assume that Total is in the 4th column which is D. Set your
conditional format for say D2 to the following:-

=$D2 < 10

Copy cell D2 and then Paste Special -> Formats to cells A2:C2.

The $ sign in front of the column id makes the column absolute so that when
you copy and paste the formats to other cells on the same row it is always
referring to the value in column D.

Actually you can pre-select the range for the conditional format and then
apply the formula as if you are just applying it to the Active Cell. (The
active cell is normally the first cell selected in the range and it remains
white rather than highlighted.) Excel then applies the correct formula to the
other selected cells and you do not have to go through the exercise of copy
-> paste special -> formats.
 
Ok, I will give it a try.
Seems like a lot to chew on for a newbie like me.
The example was a simplified version of what I am trying to accomplish.
Really,I am trying to do a conditional format for the column to the left of
"total".
It is all about gross margins.
Thanks, I will give it a go. Thanks
 
Back
Top