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 / New Users / April 2007

Tip: Looking for answers? Try searching our database.

Conditional Formatting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
James E Middleton - 06 Apr 2007 07:14 GMT
I know that there is a limit to 3 conditions, however I was wondering of
there was a way to write a formula for the following:

I have a schedule for classes grades 1,3,&5. Each grade has 4 classes,
A,B,C,D, so a total of 12 classes.

I made a schedule in Excel and I want to color code all the grades
differently, e.g., grade 1 in yellow, 2 in blue, and 5 in green.

In the cells for different periods and different days of the week I've typed
1A, 1B, 1C, 1D, 3A, 3B, etc.

Now when I open Conditional formatting, if I want to use cell is equal to, I
could only format the first three, 1A, 1B, 1C...

Could I write a formula that does the formatting: all cells with the number
1 and a letter are yellow, all cells with the number 3 plus a letter are
blue?

Thanks!
T. Valko - 06 Apr 2007 07:43 GMT
You can use the Formula Is option and use a formula something like this:

Condition 1
=LEFT(A1)="1"

Condition 2
=LEFT(A1)="2"

Condition 3
=LEFT(A1)="3"

Biff

>I know that there is a limit to 3 conditions, however I was wondering of
>there was a way to write a formula for the following:
[quoted text clipped - 16 lines]
>
> Thanks!

Rate this thread:






 
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.