Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Conditional Formatting help

Comment:

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? Thanks, Jared

Name: Mike (by mmcconaghy)
Date: August 20, 2009 at 11:40:43 Pacific

Reply:

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: =IF(LEFT(A1,3)="VAC",TRUE,FALSE) Sub Menu Format : 6th - Patterns 7th - Choose a Pretty Color 8th - Press OK 9th - Press OK MIKE http://www.skeptic.com/

0

Reply:

Beautiful! Thanks so much for your help

0

Name: Mike (by mmcconaghy)
Date: August 20, 2009 at 15:27:27 Pacific

Reply:

Glad I could help. MIKE http://www.skeptic.com/

0

uninstall office 97 prof ...

excel hierarchical sort

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Thanks that worked kinda of it got me on the right track tho. I had to put the first Conditional formatting as my blank square other wise it was thinking that everything was less then my date and was ...

Summary: Thank you for the help.. I am still stuck unfortunately G H J Comp 1 Price Comp 2 Price Won/Loss $3,300.00 $5,500.00 Color needs to b...

Summary: Is there a way to set up conditional formating to format a cell if another cell meets a certain criteria? ie. if "cell a" > 150 then highlight "cell b" else do nothing. your help is m...