conditional formating??
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 |
conditional formating??
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 |
conditional formating??
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 |
conditional formating??
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 |
conditional formating??
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 |
conditional formating??
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 |
All times are GMT +1. The time now is 01:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com