ExcelBanter - Cell Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/115578-cell-formatting.html)

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

Yes, using conditional formatting:

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

Where A1 is the other cell you mean.
--
Two heads are better than one!

Email: subst1tut3 numb3rs for l3tt3rs...

"mikehutt" wrote:

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

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

"Jon von der Heyden" wrote:

Yes, using conditional formatting:

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

Where A1 is the other cell you mean.
--
Two heads are better than one!

Email: subst1tut3 numb3rs for l3tt3rs...

"mikehutt" wrote:

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