If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
conditional formatting
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 |
#2
|
|||
|
|||
conditional formatting
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 |
#3
|
|||
|
|||
conditional formatting
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 |
Thread Tools | |
Display Modes | |
|
|