conditional formating??

[Guest]

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

 

[Chip Pearson]

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

 

[Pete]

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

 

[Guest]

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

 

[Chip Pearson]

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

 

[Chip Pearson]

Or, faster,

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



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