Conditional format if cell = blank

's Computer Specifications

Hello,

what is the right formula to use for conditional formating for if the each
is blank (no data)? Thanks

's Computer Specifications

=A2=""

if you want the formatting to go into effect when the cell is blank

This works as well

=LEN(A2)=0

--

Regards,

Peo Sjoblom

"Cam" <(E-Mail Removed)> wrote in message
news:A0E3FDA8-6C56-4D4C-A2D9-(E-Mail Removed)...
> Hello,
>
> what is the right formula to use for conditional formating for if the each
> is blank (no data)? Thanks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Format A Cell If Row Is Blank	=?Utf-8?B?UmFpbHJk?=	Microsoft Excel Misc	2	4th Oct 2007 03:11 PM
Re: Conditional Format A Cell If Row Is Blank	Bob I	Microsoft Excel Misc	0	3rd Oct 2007 09:05 PM
RE: Conditional Format A Cell If Row Is Blank	=?Utf-8?B?Ymo=?=	Microsoft Excel Misc	0	3rd Oct 2007 09:04 PM
Re: Conditional Format A Cell If Row Is Blank	Bob I	Microsoft Excel Misc	0	3rd Oct 2007 08:56 PM
Conditional Format for Non-Blank Cell	Mike	Microsoft Excel Discussion	1	20th Feb 2004 02:36 PM