| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format
Row C has a range of text values with corresponding dollar amounts in Row D.
I would like to change the color of the text in row C and D if the text in Row C = "abc" I have used =$C1="abc" and =$C$1="abc" and it hasn't worked yet. I've also tried this if statement =IF($C1="abc",1,0) and it colors the text two rows below the row containing text 'abc'. Any help???? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Format
..... Try to avoid using merged cells at all!
"Wendy7" wrote: Sorry you are right, I meant columns C and D - While I was trying to answer what the formula was - I found the issue.... I have two merged cells at the start of the report - and if I have the formula at ($C1) then it pushes the format down 1 row from where it should be. (If I have two merged cells and the equation starts at $C1 it pushes the format down 2 rows from where it should be, etc...) However if I have 1 merged cell and I start the equation at $C2 then the format is where it should be... wow... well thanks a lot for your time! "bj" wrote: normally rows are 1,2,3... and columns are A,B,C... do you mean to columns C and D? Whwn you have the cell which does highlight selected, what does the conditional format "equation is" say? "Wendy7" wrote: Row C has a range of text values with corresponding dollar amounts in Row D. I would like to change the color of the text in row C and D if the text in Row C = "abc" I have used =$C1="abc" and =$C$1="abc" and it hasn't worked yet. I've also tried this if statement =IF($C1="abc",1,0) and it colors the text two rows below the row containing text 'abc'. Any help???? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Format
I highlighted columns C & D and entered your formula =$C1="abc" and this
worked OK. Any row C in which I entered "abc" resulted in C & D being coloured. Excel 2003 "Wendy7" wrote: Row C has a range of text values with corresponding dollar amounts in Row D. I would like to change the color of the text in row C and D if the text in Row C = "abc" I have used =$C1="abc" and =$C$1="abc" and it hasn't worked yet. I've also tried this if statement =IF($C1="abc",1,0) and it colors the text two rows below the row containing text 'abc'. Any help???? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Format
really? can you tell me why? I've just never heard of that before...
"Toppers" wrote: .... Try to avoid using merged cells at all! "Wendy7" wrote: Sorry you are right, I meant columns C and D - While I was trying to answer what the formula was - I found the issue.... I have two merged cells at the start of the report - and if I have the formula at ($C1) then it pushes the format down 1 row from where it should be. (If I have two merged cells and the equation starts at $C1 it pushes the format down 2 rows from where it should be, etc...) However if I have 1 merged cell and I start the equation at $C2 then the format is where it should be... wow... well thanks a lot for your time! "bj" wrote: normally rows are 1,2,3... and columns are A,B,C... do you mean to columns C and D? Whwn you have the cell which does highlight selected, what does the conditional format "equation is" say? "Wendy7" wrote: Row C has a range of text values with corresponding dollar amounts in Row D. I would like to change the color of the text in row C and D if the text in Row C = "abc" I have used =$C1="abc" and =$C$1="abc" and it hasn't worked yet. I've also tried this if statement =IF($C1="abc",1,0) and it colors the text two rows below the row containing text 'abc'. Any help???? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Format
normally rows are 1,2,3... and columns are A,B,C...
do you mean to columns C and D? Whwn you have the cell which does highlight selected, what does the conditional format "equation is" say? "Wendy7" wrote: Row C has a range of text values with corresponding dollar amounts in Row D. I would like to change the color of the text in row C and D if the text in Row C = "abc" I have used =$C1="abc" and =$C$1="abc" and it hasn't worked yet. I've also tried this if statement =IF($C1="abc",1,0) and it colors the text two rows below the row containing text 'abc'. Any help???? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Format
.... because it can/does cause the (type of) problem(s) you experienced.
"Wendy7" wrote: really? can you tell me why? I've just never heard of that before... "Toppers" wrote: .... Try to avoid using merged cells at all! "Wendy7" wrote: Sorry you are right, I meant columns C and D - While I was trying to answer what the formula was - I found the issue.... I have two merged cells at the start of the report - and if I have the formula at ($C1) then it pushes the format down 1 row from where it should be. (If I have two merged cells and the equation starts at $C1 it pushes the format down 2 rows from where it should be, etc...) However if I have 1 merged cell and I start the equation at $C2 then the format is where it should be... wow... well thanks a lot for your time! "bj" wrote: normally rows are 1,2,3... and columns are A,B,C... do you mean to columns C and D? Whwn you have the cell which does highlight selected, what does the conditional format "equation is" say? "Wendy7" wrote: Row C has a range of text values with corresponding dollar amounts in Row D. I would like to change the color of the text in row C and D if the text in Row C = "abc" I have used =$C1="abc" and =$C$1="abc" and it hasn't worked yet. I've also tried this if statement =IF($C1="abc",1,0) and it colors the text two rows below the row containing text 'abc'. Any help???? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Format
Sorry you are right, I meant columns C and D -
While I was trying to answer what the formula was - I found the issue.... I have two merged cells at the start of the report - and if I have the formula at ($C1) then it pushes the format down 1 row from where it should be. (If I have two merged cells and the equation starts at $C1 it pushes the format down 2 rows from where it should be, etc...) However if I have 1 merged cell and I start the equation at $C2 then the format is where it should be... wow... well thanks a lot for your time! "bj" wrote: normally rows are 1,2,3... and columns are A,B,C... do you mean to columns C and D? Whwn you have the cell which does highlight selected, what does the conditional format "equation is" say? "Wendy7" wrote: Row C has a range of text values with corresponding dollar amounts in Row D. I would like to change the color of the text in row C and D if the text in Row C = "abc" I have used =$C1="abc" and =$C$1="abc" and it hasn't worked yet. I've also tried this if statement =IF($C1="abc",1,0) and it colors the text two rows below the row containing text 'abc'. Any help???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom format or conditional format? | Excel Discussion (Misc queries) | |||
| How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
| Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
