PC Review


Reply
Thread Tools Rate Thread

Conditional formatting for blank cell on report

 
 
tc2004
Guest
Posts: n/a
 
      30th Sep 2009
I would like to have blank cells for a control show either shaded or with a
border on the control. However, I am not able to produce any conditional
format for the control.

The control has integer format.

I have tried:
Field value is equal to Null / IsNull

 
Reply With Quote
 
 
 
 
Gina Whipp
Guest
Posts: n/a
 
      2nd Oct 2009
tc2004,

Have you tried "" ?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"tc2004" <(E-Mail Removed)> wrote in message
news:49B37D24-4A83-448E-8123-(E-Mail Removed)...
>I would like to have blank cells for a control show either shaded or with a
> border on the control. However, I am not able to produce any conditional
> format for the control.
>
> The control has integer format.
>
> I have tried:
> Field value is equal to Null / IsNull
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting formula for when 1 cell if blank _and_ another cell is not? StargateFanNotAtHome Microsoft Excel Discussion 2 11th Aug 2008 06:08 PM
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... amorrison2006@googlemail.com Microsoft Excel Programming 2 7th Jun 2007 09:27 PM
conditional formatting:highlight row based on blank or non-blank c =?Utf-8?B?TmF0IE1heHdlbGw=?= Microsoft Excel Programming 4 1st Dec 2005 01:11 AM
conditional formatting:highlight row based on blank or non-blank c =?Utf-8?B?TmF0IE1heHdlbGw=?= Microsoft Excel Misc 2 30th Nov 2005 11:30 PM
conditional formatting:highlight row based on blank or non-blank c =?Utf-8?B?TmF0IE1heHdlbGw=?= Microsoft Excel Worksheet Functions 2 30th Nov 2005 11:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:47 PM.