Thread: Cell Formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon von der Heyden Jon von der Heyden is offline
external usenet poster
 
Posts: 15
Default Cell Formatting

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?