Hi,
Go to conditional formating, new rule, the last option from the Select a
rule type is the "use a formula to determine which cells to format"

"Scooter" wrote:

I am using Excel 2007 and when I click on conditional formatting I do not see
"Formula is"

"Luke M" wrote:

Select all three cells (Hold Ctrl to select inidvidual cells)
goto: Format-Conditional Format.
Change first box to "Formula is"
Input:
=AND($C$43=$C$45,$C$43=$C$49)
Click format, go to pattern tab, and select green.
Hit 'ok' to close dialogue.

Now, with all 3 cells still selected, format the cells red (as you would
normally). Now, your cells will be red by default, unless they meet your
criteria (as you desired).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Scooter" wrote:

I have three cells that i would like to be green if they all equal each other
and red if they do not.

Here is an example:
C43 the value is $10.00
C45 the value is $10.00
C49 the value is $10.00

If all three equal each other then I want all three cells to turn green. If
one or more of the values do not match then I want all three to turn red