Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditonal formatting
Hi,
Could you please smdy suggest a decision for the following problem. I have excel 2007, i do conditional formatting for the row. For example, if B2<D2<C2, then D2 is red. It is simple and I know how to do it. After that I want to make the same clause for the whole row D, but for every cell should be applied smth like that B3<D3<C3 appropriately. B4<D4<C4 But when I do formal painter or simply copy paste the cell the rule became the same. Like B2<D3<C2, B2<D4<C2. I hope I was clear in focusing of my problem Any decisions are welcome cause it is not appropriate for me to create/edit a formatting rule for every cell |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditonal formatting
Did B2<C2<D2 work?
I think you need the formula =AND(B2<C2,C2<D2) You can then paint the formula to other cells... If you want to compare B2 to C2 and C2 to D2 for the whole row then use =AND($B2<$C2,$C2<$D2) "Lapa" wrote: Hi, Could you please smdy suggest a decision for the following problem. I have excel 2007, i do conditional formatting for the row. For example, if B2<D2<C2, then D2 is red. It is simple and I know how to do it. After that I want to make the same clause for the whole row D, but for every cell should be applied smth like that B3<D3<C3 appropriately. B4<D4<C4 But when I do formal painter or simply copy paste the cell the rule became the same. Like B2<D3<C2, B2<D4<C2. I hope I was clear in focusing of my problem Any decisions are welcome cause it is not appropriate for me to create/edit a formatting rule for every cell |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditonal formatting
Sheloo, thanks for your answer, but the question is not in the formula. the question is how to format the cells (for example, make them red)on the same manner as for the first cell in the row. how to make the similar formatting for every cell in the row. "Sheeloo" wrote: Did B2<C2<D2 work? I think you need the formula =AND(B2<C2,C2<D2) You can then paint the formula to other cells... If you want to compare B2 to C2 and C2 to D2 for the whole row then use =AND($B2<$C2,$C2<$D2) "Lapa" wrote: Hi, Could you please smdy suggest a decision for the following problem. I have excel 2007, i do conditional formatting for the row. For example, if B2<D2<C2, then D2 is red. It is simple and I know how to do it. After that I want to make the same clause for the whole row D, but for every cell should be applied smth like that B3<D3<C3 appropriately. B4<D4<C4 But when I do formal painter or simply copy paste the cell the rule became the same. Like B2<D3<C2, B2<D4<C2. I hope I was clear in focusing of my problem Any decisions are welcome cause it is not appropriate for me to create/edit a formatting rule for every cell |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditonal formatting
I thought I had answered that -
If you want to compare B2 to C2 and C2 to D2 for the whole row then use =AND($B2<$C2,$C2<$D2) Suppose you want to highlight the entire row RED if cell in COl A has the number 10 then select the whole row (say row 1) or select it from A1 to the column you want highlighted and enter the following in FORMULA IS =$A1=10 and choose the formatting RED... Now you can paint the format onto other rows. =AND($B2<$C2,$C2<$D2) applied on Row 2 will highlight it if B2<C2 and C2<D2 "Lapa" wrote: Sheloo, thanks for your answer, but the question is not in the formula. the question is how to format the cells (for example, make them red)on the same manner as for the first cell in the row. how to make the similar formatting for every cell in the row. "Sheeloo" wrote: Did B2<C2<D2 work? I think you need the formula =AND(B2<C2,C2<D2) You can then paint the formula to other cells... If you want to compare B2 to C2 and C2 to D2 for the whole row then use =AND($B2<$C2,$C2<$D2) "Lapa" wrote: Hi, Could you please smdy suggest a decision for the following problem. I have excel 2007, i do conditional formatting for the row. For example, if B2<D2<C2, then D2 is red. It is simple and I know how to do it. After that I want to make the same clause for the whole row D, but for every cell should be applied smth like that B3<D3<C3 appropriately. B4<D4<C4 But when I do formal painter or simply copy paste the cell the rule became the same. Like B2<D3<C2, B2<D4<C2. I hope I was clear in focusing of my problem Any decisions are welcome cause it is not appropriate for me to create/edit a formatting rule for every cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditonal Formatting | Excel Discussion (Misc queries) | |||
Conditonal Formatting | Excel Worksheet Functions | |||
conditonal formatting in VB | Excel Worksheet Functions | |||
Conditonal formatting | Excel Discussion (Misc queries) | |||
Conditonal Formatting | Excel Discussion (Misc queries) |