I need to be able to assign colors to cells depending on what text is inputted.
If a name start with letters between:
A - Cald (I want the cell to be Yellow)
Call - Eg (I want the cell to be Black)
Ek - Hall (I want the cell to be Red)
Etc.....
Can someone please help?
Select the cell, then do Format > Conditional Formatting
Condition 1, Formula is, =left(a1, 8) = "A - Cald" and format as yellow, then press Add,
Condition 2, Formula is, =left(a1, 9) = "Call - Eg" and format as black, then press Add,
Condition 3, Formula is, =left(a1, 9) = "Ek - Hall" and format as red.
In each case, replace a1 with the address of the cell.
To do more than three formats requires either Excel 2007 or VBA.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Thanks but I can't get this to work with Excel 2007. How do I plug in these formulas in 2007, it is so confusing. I miss my Excel 2003.
..Sorry, I though I selected Excel 2007 forum help.
Home > Conditional Formatting > Manage Rules, New Rule, Use a formula ...
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
What I am using as a Rule type?
Home > Conditional Formatting > Manage Rules, New Rule, Use a formula ...
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Yeah, that's what I was using. It's not working.
See attached.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
I need it to work, for example:
....... Column A
Row
1..... Alexandra (This cell needs to be Yellow)
2..... Cannon (This cell needs to be Yellow)
3..... Claudia (This cell needs to be Black)
4..... Eagor (This cell needs to be Black)
5..... Elk (This cell needs to be Red)
If the formats are static by row, apply static formats. If you need more rules, add more rules.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks