View Single Post
 
Old 07-03-2014, 10:07 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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