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

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

Press F5 (Go To) then click Special and select blanks. Type the word
"NEED" then press CTRL-ENTER rather than <enter.

Hope this helps.

Pete

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

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

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