Conditional formatting - check for blank cell
In Excel 2003, I'd like to apply colored shading to a cell if it's blank.
I select: Cell Value Is equal to "" When I check it, the value box contains: ="""""" (6 quotation marks) I can edit the value so it reads: ="" (2 quotation marks) and that works. But there's got to be an easier way to enter a conditional format to check for a blank cell. Any suggestions? Thanks. |
Conditional formatting - check for blank cell
Not sure whether this is "easier", but you could always select the range, eg
select A1:E10 (with A1 active), then apply CF using Formula Is: =ISBLANK(A1) Format to taste ok out aha? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Eric_NY" wrote: In Excel 2003, I'd like to apply colored shading to a cell if it's blank. I select: Cell Value Is equal to "" When I check it, the value box contains: ="""""" (6 quotation marks) I can edit the value so it reads: ="" (2 quotation marks) and that works. But there's got to be an easier way to enter a conditional format to check for a blank cell. Any suggestions? Thanks. |
Conditional formatting - check for blank cell
FormatCFFormula is: =ISBLANK(cellref)
Gord Dibben MS Excel MVP On Tue, 18 Aug 2009 07:16:01 -0700, Eric_NY wrote: In Excel 2003, I'd like to apply colored shading to a cell if it's blank. I select: Cell Value Is equal to "" When I check it, the value box contains: ="""""" (6 quotation marks) I can edit the value so it reads: ="" (2 quotation marks) and that works. But there's got to be an easier way to enter a conditional format to check for a blank cell. Any suggestions? Thanks. |
Conditional formatting - check for blank cell
Thanks to you both.
"Gord Dibben" wrote: FormatCFFormula is: =ISBLANK(cellref) Gord Dibben MS Excel MVP On Tue, 18 Aug 2009 07:16:01 -0700, Eric_NY wrote: In Excel 2003, I'd like to apply colored shading to a cell if it's blank. I select: Cell Value Is equal to "" When I check it, the value box contains: ="""""" (6 quotation marks) I can edit the value so it reads: ="" (2 quotation marks) and that works. But there's got to be an easier way to enter a conditional format to check for a blank cell. Any suggestions? Thanks. |
All times are GMT +1. The time now is 02:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com