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 / Worksheet Functions / January 2004

Tip: Looking for answers? Try searching our database.

Cell color

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bubba - 21 Jan 2004 06:39 GMT
Hi,
Like RickyDee, I am trying to figure out how to have a
cell change color automatically.  But I dont' think he's
on the same track as I am.

I'll write it out in 'long hand'.

If b1 > C1 then change D1 to GREEN and place OVER in D1
If b1 < C1 then change D1 to RED and place UNDER in D1

Can't seem to find this in the HELP file, and conditional
formatting doesn't seem to want to go that far.  

Thank you.
Norman Harker - 21 Jan 2004 08:55 GMT
Hi Bubba!

You can't do it in one operation.

In D1 put:
=IF(B1>C1,"OVER",IF(B1<C1,"UNDER","EQUAL"))

The apply conditional formatting to D1

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 
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



©2010 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.