Conditional Formatting help

Microsoft Excel 2003 (full)
August 20, 2009 at 11:05:11
Specs: Windows Vista
I am looking to set up conditional formatting based on the first 3 letters of a particular cell. So if the cell says VACMOM or VACDAD or VACSISTER the cell would change colors but if it said VICKY or VERONICA it would stay the same. Can anyone help?


See More: Conditional Formatting help

Report •

August 20, 2009 at 11:40:43
OK, here’s a simple solution:

1st – Select the cell A1 and enter VACMOM or VACDAD or VACSISTER.

On the Menu Bar:

2nd - Format
3rd - Conditional Formatting
4th – Change “Cell Value is” to “Formula Is”
5th – Enter the formula:


Sub Menu Format :
6th - Patterns
7th - Choose a Pretty Color
8th - Press OK
9th - Press OK


Report •

August 20, 2009 at 11:49:35
Beautiful! Thanks so much for your help

Report •

August 20, 2009 at 15:27:27
Glad I could help.


Report •

Related Solutions

Ask Question