I was wondering if anyone has ever tried to format a cell based off of
another cell's value. Esentially I am trying to set up a spreadsheet that
would do something similar to the following, if cell1 is blank or 0 then
cell3 should be blank. cell3 currently has a formula in it that is
calculating a number based off of another cell and cell1. However I dont want
the value of cell3 to be 0 cause later i will have another cell calculate
based off of cell3. Thanks

cell1 | cell2 | cell3 |

If Cell1 is C6, for example:

Select Cell3. Then select Format Conditional Formatiing (in Excel 2003).
Change the dropdown box to "Formula Is". In the adjoining text box, enter
this formula:

=OR(LEN(C6)=0,C6=0)

Click the Format button. On the Font tab, change the color to white (or
whatever the background color is for Cell3). Click OK, then OK.

Hope this helps,

Hutch

"whwar_9739" wrote:

I was wondering if anyone has ever tried to format a cell based off of
another cell's value. Esentially I am trying to set up a spreadsheet that
would do something similar to the following, if cell1 is blank or 0 then
cell3 should be blank. cell3 currently has a formula in it that is
calculating a number based off of another cell and cell1. However I dont want
the value of cell3 to be 0 cause later i will have another cell calculate
based off of cell3. Thanks

cell1 | cell2 | cell3 |

I was wondering if anyone has ever tried to format a cell based off of
another cell's value. Esentially I am trying to set up a spreadsheet
that would do something similar to the following, if cell1 is blank or
0 then cell3 should be blank. cell3 currently has a formula in it that
is calculating a number based off of another cell and cell1. However I
dont want the value of cell3 to be 0 cause later i will have another
cell calculate based off of cell3. Thanks

If a cell's font color is the same as its background color, it appears
blank even though its value may be anything.

This can be used in conditional formatting to get the result you describe.