 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Best approach for conditional formatting?
I would like to make numbers within certain ranges show up in different colors. I'm very new to Excel, but have programmed scripts in Access and know what an Access macro is - as well as the Access "conditional formatting" feature. What is the best approach to take in Excel? And could you give me some pointers as to the first steps to take to get into the recommended environment? You'll need to describe what kind of data will be in the cells and which formats would be associated with which data values. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) >I would like to make numbers within certain ranges show up in different >colors. I'm very new to Excel, but have programmed scripts in Access and >know what an Access macro is - as well as the Access "conditional >formatting" feature. What is the best approach to take in Excel? And >could you give me some pointers as to the first steps to take to get into >the recommended environment? Numeric data <80 would remain black - no extra steps. 81>90 - blue 91-100 - red above 100- fuschia > You'll need to describe what kind of data will be in the cells > and which formats would be associated with which data values. [quoted text clipped - 13 lines] >>could you give me some pointers as to the first steps to take to get into >>the recommended environment? Click on FORMAT > Conditional Formatting Condition 1: Cell Value Is Between 81 90 (Set Format) Condition 2: Cell Value Is Between 91 100 (Set Format) Condition 3: Cell Value Is Greater Than 100 (Set Format) Good Luck, Les > Numeric data <80 would remain black - no extra steps. > 81>90 - blue [quoted text clipped - 18 lines] > >>could you give me some pointers as to the first steps to take to get into > >>the recommended environment? Perfect!!! Thanks so much! I can't believe I couldn't find that "conditional formatting" menu item. It's in just the obvious place. (Maybe that's the problem .... Who would look in the obvious place???? :-) ) > Click on FORMAT > Conditional Formatting > [quoted text clipped - 29 lines] >> >>into >> >>the recommended environment?
|
Reply to this Message |
 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.