Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Formatting/Formulas

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
aloken - 28 May 2008 21:35 GMT
I want to be able to have my cells highlighted yellow until I place
information into them.  I have done it before but can't rember what function
to use.
Peo Sjoblom - 28 May 2008 21:45 GMT
Format>conditional formatting>formula is

=A2=""

click format button and pattern, select yellow and click OK twice

replace A2 with the first cell of a selected range for instance if you want
this to
happen in C2:C100, select that range and use

=C2=""

with C2 as the active cell

Signature

Regards,

Peo Sjoblom

>I want to be able to have my cells highlighted yellow until I place
> information into them.  I have done it before but can't rember what
> function
> to use.
Kevin B - 28 May 2008 21:57 GMT
Select the cells to format and click FORMAT in the menu and select
CONDITIONAL FORMATTING.

In the CONDITIONAL FORMATTING dialog box, change CONDITION 1 to FORMULA IS
and in the text box to the right enter the following formula, changing the A1
in the example to the starting cell of your selected range:

=ISBLANK(A1)

Or if you want to treat any errant spacebar entry as a blank cell

=LEN(TRIM(A1))=0

Click the FORMAT command button, select the PATTERNS tab and select the
color you want and click OK 2 times to exit.

Signature

Kevin Backmann

> I want to be able to have my cells highlighted yellow until I place
> information into them.  I have done it before but can't rember what function
> to use.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.