conditional formating??

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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"
 
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
 
Or, faster,

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



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