Or, faster,

Range("A1:A10").SpecialCells(xlCellTypeBlanks).Val ue = "need"



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Chip Pearson" wrote in message
...
The only way is to use a macro.

Sub AAA()
Dim Rng As Range
On Error GoTo End_Macro
For Each Rng In Range("A1:A10").SpecialCells(xlCellTypeBlanks)
'< change
Rng.Value = "need"
Next Rng
End_Macro:
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Daveed" wrote in message
...
is their an alternative way to achieve this, where a cell
range if blank
contains the word "need"

"Chip Pearson" wrote:

You can't. Conditional Formatting can't insert text into a
cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Daveed" wrote in message
...
i would like the word "need" to appear in cells that are
blank.
i can do
something similar with conditional formating where the
blank
cells turn red
when empty... but i cant figure out how to have words
inserted
instead.

Thanks