Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying conditon formats with $
My 2 cell conditional format works perfect,
But I can't copy a 4 cel copy and Paste special down the column , I think because the $ signs are in th conditionals. I'm not sure why they are there, but I know if I remove the $ sign for the copy paste special or past, My conditionals Split colors or remain. Formula in O7 is: =IF(COUNT(D7:N7)0,SUM(D7:N7),"") Conditional formulas in O6,O7 =AND(O$7<"",O$7<=0) Green =AND(O$7<"",O$7=1) Red I wanted cells until data appeared. All works fine, cept. I can not copy it down some 800 lines thru O871 I have text every 4th line. IS there a way to copy this down and have he cell numbers change with it, an keep the integrity of the Formula and the conditionals? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
Get data with certain conditon | Excel Discussion (Misc queries) | |||
How to determine the number from given conditon? | Excel Discussion (Misc queries) | |||
Copying Formats | Excel Discussion (Misc queries) | |||
copying conditional formats | Excel Worksheet Functions |