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.

color formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lisa - 24 May 2008 23:52 GMT
i am working on a spread sheet. i have set up that everytime i enter a number
the cell next to or two down adds 250 when i enter the first number is it
possible to make the cell with the added 250 turn red.
dksaluki - 25 May 2008 00:34 GMT
not completely sure i understand your question, but you could put in a
conditional format that basically says: "if this cell's value is more
that 250, turn red."

to do this, click the cell that you want to turn red.  Then on the
main menu, click FORMAT > CONDITIONAL FORMATTING...
Then set it to "Cell value is.....greater than....250".  Then click
the format button and on the patterns tab, click the red color.  clidk
OK..and OK

hope this helps,
dk
 
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.