How do I autofill colors, based on input of text

**crizzle** · 06-16-2008, 01:42 PM

Or atleast this being my first day working with excel formula's... its tricky to me. lol. im at work and i'm working on a project that will allow us to track our airplanes. i dont know if its ok to ask this in here, but o well...

what i'm trying to do is have a formula that when certain text is typed into column 'b' (fmc, nmcmc, etc... anyways..) when an airplane is 'fmc' its 'green' and i want the aircrafts tail number block in column 'a' to autofill in with a green color, and when its 'nmcmc, i want it to be red. when its 'bq' i want it to autofill in as yellow.

maybe your wondering why i need it this way, well... my boss makes the rules. lol so thats why. if anyone can point me in the right direction i would be greatly appreciative. thanks in advance =)

**NBVC** · 06-16-2008, 01:44 PM

Please take the time to read our forum rules prior to posting.

Then amend your title to suit the question you're asking.

**BigBas** · 06-16-2008, 01:44 PM

Reseach "Conditional Formatting". That should solve the issue at hand.

**crizzle** · 06-16-2008, 02:04 PM

yea, sorry about that, i read the rules (now, lol), but dont know how to change the title...

**VBA Noob** · 06-16-2008, 02:32 PM

Thank you. There is a suggestion below from BigBas

VBA Noob

**crizzle** · 06-16-2008, 03:08 PM

bigbas, thanks for the suggestion, however i've been trying that. make i'm just clueless (its very possible, i know..) all i need excel to do is when i type 'fmc' in column 'b' then the corresponding row in column 'a' will fill in with a green color, and the same technique but when i type 'nmcmc' in column 'b' to fill a red color in the coressponding row in column 'a' i'm using both exel 2003 (at work) and the new version (whichever is on vista..) at home. this isnt my normal job, i just wanted to do this little project my annual review is comming up and i wanna add something extra.. uughh...military.... hope anyone can help. =)

**NBVC** · 06-16-2008, 03:15 PM

So you selected column A... went to Format|Conditional Formatting...

Chose Formula Is from 1st drop down and entered formula: =B1="fmc"

Clicked Format and chose green colour...

Clicked Add and repeated above with =B1="nmcmc" and chose red

repeated and used formula =B1="bq" and chose yellow...

?

**crizzle** · 06-16-2008, 03:21 PM

=) like i said, i'm a little... uumm.... slow... lol. yes it worked like a champ.

**crizzle** · 06-16-2008, 03:37 PM

one more thing, i promise, i know i can only have 3 conditional formats, however like i mentioned before i need only 3 colors (green, red, and yellow) but i have different aircraft status, nmcmc, nmcmd, nmcse (all of those should be displayed in red) but i tried figuring it out myself and no luck... can you point me in the write direction? thanks so much for all the help =)