Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do copy a conditional format formula downards?
Hi,
I have a pivot-table that contains anything between 20 to 100 rows and I want to highlight a row if a column value contains a particular integer. So, I guess I make a rule for the first row (a4: h4). Then I need to copy down this rule to a100:h100, but how? (The conditional format is: =$a1="Outcome"). I'm using Excel 2007. Kindly, Mikael Sweden |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do copy a conditional format formula downards?
Have you tried using the Format Painter icon? Highlight row 1, click
the icon, then click on the row(s) you want to apply the format to. Hope this helps. Pete On Nov 16, 8:57 am, Mikael Lindqvist wrote: Hi, I have a pivot-table that contains anything between 20 to 100 rows and I want to highlight a row if a column value contains a particular integer. So, I guess I make a rule for the first row (a4: h4). Then I need to copy down this rule to a100:h100, but how? (The conditional format is: =$a1="Outcome"). I'm using Excel 2007. Kindly, Mikael Sweden |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
Copy Formula Is conditional format | Excel Worksheet Functions | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
How do I copy a conditional format that uses a formula in a serie. | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |