Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |