Cell Formatting

M

mikehutt

Is it possible to set the formatting in a cell (greying out text) if a
different cell has any content?
 
J

Jon von der Heyden

Yes, using conditional formatting:

Format -> Conditional Formatting
Choose Formula is: =NOT(ISBLANK(A1))

Where A1 is the other cell you mean.
 
M

mikehutt

Jon,

Thank you - that really helped. I have another related problem.
I want to do the same formatting, but if an existing formula in the related
cell has a value >0 (becuase there is a formula there is always has something
in the cell - either 0 or another value. I tried cell value, greater than,
-0(CellRef) but it doesn't work. Any ideas. Thanks a lot
 
Top