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.

--
Regards,

OssieMac


"Charles Eaves" wrote:

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

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
"OssieMac" wrote in message
...
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.

--
Regards,

OssieMac


"Charles Eaves" wrote:

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