Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format for the whole row
I found on one of the other posts how to do a row conditional format
using this formula in the "Formula is" option: =(A1="variable1")+(A1="variable2") Now the problem I'm having is when I want to copy them down for the rest of my rows, they either get get scrambled with colors or just follow colors of the very first row I copied. I'm guessing the obvious reason has every bit to do with the $ sign in the conditional format. So I tried to write it without it as well. But by doing that, the whole row defaults to no color. What can I do to make it copy correctly? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format for the whole row
Hi
Try =MOD(ROW(),2)=1 if you want to format the odd row numbers or =MOD(ROW(),2)=0 to format even row numbers -- Regards Roger Govier wrote in message ups.com... I found on one of the other posts how to do a row conditional format using this formula in the "Formula is" option: =(A1="variable1")+(A1="variable2") Now the problem I'm having is when I want to copy them down for the rest of my rows, they either get get scrambled with colors or just follow colors of the very first row I copied. I'm guessing the obvious reason has every bit to do with the $ sign in the conditional format. So I tried to write it without it as well. But by doing that, the whole row defaults to no color. What can I do to make it copy correctly? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format for the whole row
You're right. It is to do with the $ signs.
If you've used A1 in the formatting for cell A1 (and copied down & across), then each cell will be formatted according to its own contents. If you use $A1, then the whole of each row will be formatted according to the content of column A in that row. If you use A$1, then the format of each column will be governed by the content of row 1 in that column. If you use $A$1, then the whole range (rows and columns) will be governed by the content of cell A1. -- David Biddulph wrote in message ups.com... I found on one of the other posts how to do a row conditional format using this formula in the "Formula is" option: =(A1="variable1")+(A1="variable2") Now the problem I'm having is when I want to copy them down for the rest of my rows, they either get get scrambled with colors or just follow colors of the very first row I copied. I'm guessing the obvious reason has every bit to do with the $ sign in the conditional format. So I tried to write it without it as well. But by doing that, the whole row defaults to no color. What can I do to make it copy correctly? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format for the whole row
Roger,
Thank you. However, while this could be useful if I need to alternate rows, I am more in need of the colors to follow according to the conditions set by the user. What David wrote hit the exact spot that I needed. For any one searching for anything similar, I should also specify that I wanted the rows to be colored according to the content in one column. So to follow what David said, make sure you keep the $ sign in front of the letter or the column in your formula and not on the number of the row to keep the column as the consistent value the condition is following. Jackson Hi Try =MOD(ROW(),2)=1 if you want to format the odd row numbers or =MOD(ROW(),2)=0 to format even row numbers -- Regards Roger Govier wrote in message ups.com... I found on one of the other posts how to do a row conditional format using this formula in the "Formula is" option: =(A1="variable1")+(A1="variable2") Now the problem I'm having is when I want to copy them down for the rest of my rows, they either get get scrambled with colors or just follow colors of the very first row I copied. I'm guessing the obvious reason has every bit to do with the $ sign in the conditional format. So I tried to write it without it as well. But by doing that, the whole row defaults to no color. What can I do to make it copy correctly?- Hide quoted text - - Show quoted text - |
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) |