| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting
Is it possible to set the formatting in a cell (greying out text) if a
different cell has any content? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Formatting
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions | |||
| Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
| Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| xls worksheet formatting a single cell | Excel Discussion (Misc queries) | |||
Linear Mode
