J J.E. McGimpsey Dec 9, 2003 #2 Look at Conditional Formatting in XL Help. Set the Font color to the background color when the cell value is 0.
Look at Conditional Formatting in XL Help. Set the Font color to the background color when the cell value is 0.
M Mike A Dec 10, 2003 #3 You could also wrap your formula in an IF() function that returns null if your formula result is zero: =IF(yourformula=0."",yourformula) Replace yourformula in the above function with the formula (without the leading =) in the cells you want zeroes blanked in. =A1+B1 becomes =IF(A1+B1=0,"",A1+B1) -Mike Is there a way to blank zero values in only a section of a sheet? TIA Jerry Click to expand... Mike Argy Custom Office Solutions and Windows/UNIX applications Please post on-topic responses to the newsgroup To e-mail me, remove nospam from the address in the headers
You could also wrap your formula in an IF() function that returns null if your formula result is zero: =IF(yourformula=0."",yourformula) Replace yourformula in the above function with the formula (without the leading =) in the cells you want zeroes blanked in. =A1+B1 becomes =IF(A1+B1=0,"",A1+B1) -Mike Is there a way to blank zero values in only a section of a sheet? TIA Jerry Click to expand... Mike Argy Custom Office Solutions and Windows/UNIX applications Please post on-topic responses to the newsgroup To e-mail me, remove nospam from the address in the headers
