Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2007 conditional formatting question
i really don't like excel 2007, but i'm playing around with the conditional
formatting color scales, data bars, etc. i have data in columns c:e i apply cond formatting to row 2, it's correct, this is the formula it creates: =$C$2:$E$2 if i copy formatting one row at a time it works correctly: =$C$3:$E$3 but, if i replicate the formatting, using format painter or copy/formats, for multiple rows, i end up with this formula for row 27: =$C$3:$E$27 can someone explain this to me? -- Gary Keramidas Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting in Excel 2007 | Excel Worksheet Functions | |||
conditional formatting excel 2007 | Excel Discussion (Misc queries) | |||
Office 2007 Conditional Formatting question | Excel Discussion (Misc queries) | |||
More Conditional Formatting in Excel 2007 | Excel Worksheet Functions | |||
Conditional Formatting In Excel 2007 | Excel Discussion (Misc queries) |