Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 07-03-2014, 09:00 AM
info_guy2 info_guy2 is offline Mac OS X Office for Mac 2011
Join Date: Jul 2014
Posts: 1
info_guy2 is on a distinguished road
Default Conditional formatting that ignores other formatting rules

I'm working on a spreadsheet with a large list of schools, and color coding them based upon the grades they serve. Currently, the conditional formatting rules use the name of the school ("Elementary" in the name is colored green," Middle School or Jr High is colored red, etc.). However, there are some schools with the name Elementary in it that actually serve grades Kindergarden through 8th grade, while the definition of elementary that I have been using is generally Kindergarden through 5th grade.

I want to color code these K-8 schools blue, and can do so manually, but only if the school name does not have "elementary" or "grade school" in it. Is there a formula that both pays attention to a "Grades Served" field that is in the spreadsheet and overrides the "contains Elementary" or "contains grade school" name rule?

Let me know if I need to provide any more information. Thanks!
Reply With Quote
Old 07-03-2014, 10:07 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about

You can only conditionally format a cell based on its value (or its value relative to another cell), not the value of another cell. It might be done with code, but I'll leave that to the experts.

So you cannot conditionally format the school name based on the grades served. However, you can conditionally format the school name as you say and then the grades served next to it. For those exceptions to your definition will have green names and blue grades served.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting jdc15371 Excel 2 06-26-2014 06:34 AM
Conditional Formatting. Laurie B. Excel 6 04-09-2012 05:01 PM
Conditional formatting zanat0s Excel 4 01-20-2012 03:30 AM
Conditional formatting with AND, OR Lucky Excel 2 10-03-2011 11:41 PM
Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM

All times are GMT -7. The time now is 10:06 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft