Excell color coding

Dell / Precision workstation t35...
March 17, 2010 at 08:09:00
Specs: Microsoft Windows XP Professional, 2.666 GHz / 3581 MB
I have a cell L7 if the value of L7 is "x" and yes I mean the letter x as the value, I want to make cell c7 turn yellow or red or whatever color

See More: Excell color coding

Report •

#1
March 17, 2010 at 08:20:00
It's good to want.

Are you now going to ask for help?


Report •

#2
March 17, 2010 at 09:03:01
I am asking for help, my question is
I have a cell L7 if the value of L7 is "x" and yes I mean the letter x as the value, I want to make cell c7 turn yellow or red or whatever color, can you tell me how to do this


Report •

#3
March 17, 2010 at 09:52:56
You didn't say what version of Excel you are using, but Conditional Formatting is what you are looking for.

In 2003 it's:

1 - Select C7
2 - Format...Conditional Formatting
3 - Condition 1 Drop Down: Choose "Formula Is:"

Enter: =IF(L7="x",TRUE,FALSE)

4 - Click Format and choose a Pattern color
5 - OK your way out.


Report •

Related Solutions

#4
March 17, 2010 at 10:33:12
I am do sorry, new to this, I am using office 2007, thanks so much

Report •

#5
March 17, 2010 at 11:53:53
The concept is still valid, whether it's 2003 or 2007 - Conditional Formatting is what you want to use.

I can't give you the steps-by-step fro 2007, but you can look it up in the Help files. it's fairly straight forward.

Good Luck!


Report •

#6
March 17, 2010 at 11:58:24
Hi,

If you still need help on CF in Excel 2007:

From the Ribbon select Home - Styles - Conditional Formatting,
From the drop down select 'Manage Rules' and select 'New Rule'
In the dialog box select the last item in the list 'Use a formula to determine which cells to format'
Enter your formula in the box.
Note that TRUE and FALSE do not have double quotes - they are Excel's logical values true and false.
Click the format button and from the 'Fill' Tab select a color, click OK until out.

Regards


Report •

#7
March 17, 2010 at 12:10:24
I figured it out, just as I got your response. You folks are great. I am almost done. May I ask one more question. I want a button on the form, that when they click it, it will insert the word "YES" in another cell. I would like the button in cell L107 and the word yes to appear in L108, again this is in excel 2007. I promise I will not bother you anymore. you all are great

edited by moderator: Unrelated Question


Report •

#8
March 17, 2010 at 12:24:18
Feel free to bother us whenever you need help, but please post your new question in a separate thread.

Combining questions in one thread makes the archives messy.

Thanks!

DerbyDad03
Office Forum Moderator


Report •

Ask Question