Copy Conditional Formatting down rows
Using Copy then Paste SpecialFormats still works ok for me.
Tell me *exactly* what cells you're trying to format based on what
condition.
I've *never* used the format painter so I don't know how it works.
--
Biff
Microsoft Excel MVP
"Whit" wrote in message
...
I'm trying to use the Format Painter or Copy Special/Format options to
copy
CF like I have been able to do in prior versions. In my spreadsheet, it
is
not progressing the rows like it should in a CF formula like
=AND(C120,D12<1) and acting like I have entered it as
=AND(C$120,D$12<1).
It worked for a while under some special conditions, but now no matter
what
I do it replicates the exact same formula without progressing the rows
like
it should. Is there some kind of option that I need to set, is this a
bug,
???
"T. Valko" wrote:
It works ok for me. Here are the steps I used:
Select the range A10:F10
Goto Home tabStylesConditional FormattingManage RulesNew RuleUse a
formula to determine which cells to format
=A10100
Click the Format button
Select the desired style(s)
OK out
--
Biff
Microsoft Excel MVP
"Whit" wrote in message
...
New to Office 2007, but am very frustrated. When I copy a cell's
formatting
(either by paste/special/formats or format painter) the conditional
formatting is not using the relative cell row reference but instead
always
referring back to the original cell even though I am not using the
absolute $
reference. For example:
CF = A10100 (in cell A10)
when I copy the format to B10 CF = A10100
If I copy the format to B10:F10 CF in all cells = B10100
What is going on??
|