Conditional formatting using an if function

**tays01s** · 05-22-2013, 03:50 PM

I'd like eg. cell A1 to change colour if its value is NOT equal to A2. I've tried the syntax I'd use withing a normal cell but failed.

**Jonmo1** · 05-22-2013, 03:52 PM

Try this as A1's conditional formatting formula

=NOT(A1=A2)

**tays01s** · 05-22-2013, 04:32 PM

Jonmo1: Thanks, I'm duff!

**Jonmo1** · 05-22-2013, 04:48 PM

Glad to help,
Nice to meet you duff, I'm Jon!

**nzricky** · 05-23-2013, 01:10 AM

Was wondering if someone may be able to help me, I think I am in a similar situation.

- I have a percentage value in X3, I have obtained that value via a formula =V3/U3
- I have a percentage value in W3, I have obtained that value via a formula =IF(P3=1,"0%",IF(P3=2,"20%",IF(P3=3,"30%",IF(P3=4,"50%",IF(P3=5,"100%",IF(P3>5,"100%","N/A"))))))
- I want to conditionally format X3 so that if X3 is equal to or greater than W3 then it fills Green AND if X3 is less than W3 then it fills Red.

I have tried Conditional formatting exactly what I said using cell value = or < or > then fill appropriate colour. But it just fills red no matter what the values are.

hmmm... I am stuck.

**FDibbins** · 05-23-2013, 01:15 AM

Welcome to the Forum, nzricky

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.