If the value on one cell equals the value in

Microsoft Office excel 2007 - upgrade
January 13, 2011 at 08:32:28
Specs: Windows XP
If a formula driven value in one cell matches the input value in a different cell, I want the formula driven cell to change colors.

See More: If the value on one cell equals the value in

Report •

#1
January 13, 2011 at 08:59:24
Look up Conditional Formatting in the Excel Help file.

Depending on what version you are running, the mechanics of using and applying Conditional Formatting differ.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 13, 2011 at 09:06:18
I am using MS Office 2007 (Excel), I have tried the conditional formating, just can not seem to get what I want. If two spacific cells match, I want one to change color, or the font to change color or perhaps if they do not match. Something that will call notice.

Report •

#3
January 13, 2011 at 09:28:29
I don't have 2007 on the machine I'm sitting at, so I can't give you the exact steps to apply the Rule, but in 2003 if I use CF on A1 (or A2) and use a simple formula such as this, the CF will be applied.

=A1=A2

If I recall correctly, it's something like this in 2007:

1 - From the Ribbon select Home - Styles - Conditional Formatting,
2 - From the drop down select 'Manage Rules' and select 'New Rule'
3 - In the dialog box select the last item in the list 'Use a formula to determine which cells to format'
4 - Enter your formula in the box.
6 - Click the format button and from the 'Fill' Tab select a color, OK your way out.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
January 13, 2011 at 10:15:08
Thank you so much, that did the trick. Why I was having trouble with it I do not know. Thanks again.

Report •

Ask Question