Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting and Printing
i have a column with formula in cell E2, =$e1+$d2 and copied down 14
rows. cell E2 is conditionally formatted 'cell value is equal to $e1 format font color white' and the other 14 cells formatted the same. works ok on the screen but print preview and print on paper prints all of the values in column E whether the value is the same or different from the cell above. how come? is there a fix? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting and Printing
Jay,
Looks like you are attempting a running total. Here is a code that I have used in the past to eliminate this. It does not require the use of conditional formatting. Basically, it checks to see if D2 is blank or if there is an error summing E1+D2, which it will then return a blank, if not return the sum E1 + D2. =IF(OR(D2="",ISERROR(E1+D2)),"",E1+D2) -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''''Yes'''' below. "Jay Fincannon" wrote: i have a column with formula in cell E2, =$e1+$d2 and copied down 14 rows. cell E2 is conditionally formatted 'cell value is equal to $e1 format font color white' and the other 14 cells formatted the same. works ok on the screen but print preview and print on paper prints all of the values in column E whether the value is the same or different from the cell above. how come? is there a fix? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting and Printing
Thomas here's the thing. this sheet is for accumulated mileage for two
weeks that is turned in to payroll. however some days I don't drive so cells in column E should be blank for those days. Column A = date column B = start mileage C = ending miles D = total for that day and E = running total for two weeks. the IF/OR would work if there was mileage everyday. Jay On Wed, 8 Oct 2008 06:08:01 -0700, Thomas [PBD] wrote: Jay, Looks like you are attempting a running total. Here is a code that I have used in the past to eliminate this. It does not require the use of conditional formatting. Basically, it checks to see if D2 is blank or if there is an error summing E1+D2, which it will then return a blank, if not return the sum E1 + D2. =IF(OR(D2="",ISERROR(E1+D2)),"",E1+D2) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting and Printing
Jay,
Ah-ha. I see. Well, try this instead: E1: =IF(D1="","",D1) E2: =IF((SUM($D$1:D2)-SUM($D$1:D1))=0,"",SUM($D$1:D2)) You can pull this formula down as far as you need it. I assumed that E1 was not a header, if it is you can simply use the second formula from the first record through the last. -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Jay Fincannon" wrote: Thomas here's the thing. this sheet is for accumulated mileage for two weeks that is turned in to payroll. however some days I don't drive so cells in column E should be blank for those days. Column A = date column B = start mileage C = ending miles D = total for that day and E = running total for two weeks. the IF/OR would work if there was mileage everyday. Jay On Wed, 8 Oct 2008 06:08:01 -0700, Thomas [PBD] wrote: Jay, Looks like you are attempting a running total. Here is a code that I have used in the past to eliminate this. It does not require the use of conditional formatting. Basically, it checks to see if D2 is blank or if there is an error summing E1+D2, which it will then return a blank, if not return the sum E1 + D2. =IF(OR(D2="",ISERROR(E1+D2)),"",E1+D2) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting and Printing
what a guy! that works just like i wanted
thanks Thomas Jay On Wed, 8 Oct 2008 13:02:02 -0700, Thomas [PBD] wrote: Jay, Ah-ha. I see. Well, try this instead: E1: =IF(D1="","",D1) E2: =IF((SUM($D$1:D2)-SUM($D$1:D1))=0,"",SUM($D$1:D2)) You can pull this formula down as far as you need it. I assumed that E1 was not a header, if it is you can simply use the second formula from the first record through the last. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional printing | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Printing | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |