In Excel 2007, I want a column (C) to conditional color fill a cell if the
corresponding cell in (B) contains a certain word. I an't get the conditional
formatting to accept my IF statement. Should I be using a different function?

Example
B1 contains Accepted, C1 turns yellow
B1 contains Not Accepted, C1 turns green
B1 contains Cancelled, C1 turns hot pink
possibly others, but that's is the jist.

Thank you!

Conditional Formatting

=$B$1="Accepted"
format cell yellow

=$B$1="Not Accepted"
fomat cell green

and so on...



"mdavison" wrote:

In Excel 2007, I want a column (C) to conditional color fill a cell if the
corresponding cell in (B) contains a certain word. I an't get the conditional
formatting to accept my IF statement. Should I be using a different function?

Example
B1 contains Accepted, C1 turns yellow
B1 contains Not Accepted, C1 turns green
B1 contains Cancelled, C1 turns hot pink
possibly others, but that's is the jist.

Thank you!

Hi,

select column c and apply these 3 conditional formats
=$B1="Accepted"
click Add
=$B1="Not accepted"
click add
=$B1="Cancelled"

I'm not sure about 'Hot Pink' though :)

Mike


"mdavison" wrote:

In Excel 2007, I want a column (C) to conditional color fill a cell if the
corresponding cell in (B) contains a certain word. I an't get the conditional
formatting to accept my IF statement. Should I be using a different function?

Example
B1 contains Accepted, C1 turns yellow
B1 contains Not Accepted, C1 turns green
B1 contains Cancelled, C1 turns hot pink
possibly others, but that's is the jist.

Thank you!

Thanks Mike,
this one makes sense because obviously I don't want the row to be absolute.
But its not working 100%. I was making it WAY too complicated with an If
embeded. :)

But I have Cancelled items in Pink and Yellow which is weird and I have
Accepted records showing green. I double checked my syntax and all three are
identical. There is nothing in the data to warrant these anomalies. Where do
I look next?

"Mike H" wrote:

Hi,

select column c and apply these 3 conditional formats
=$B1="Accepted"
click Add
=$B1="Not accepted"
click add
=$B1="Cancelled"

I'm not sure about 'Hot Pink' though :)

Mike


"mdavison" wrote:

In Excel 2007, I want a column (C) to conditional color fill a cell if the
corresponding cell in (B) contains a certain word. I an't get the conditional
formatting to accept my IF statement. Should I be using a different function?

Example
B1 contains Accepted, C1 turns yellow
B1 contains Not Accepted, C1 turns green
B1 contains Cancelled, C1 turns hot pink
possibly others, but that's is the jist.

Thank you!

hi,

what percentage isn't working and what is it doing?

mike

"mdavison" wrote:

Thanks Mike,
this one makes sense because obviously I don't want the row to be absolute.
But its not working 100%. I was making it WAY too complicated with an If
embeded. :)

But I have Cancelled items in Pink and Yellow which is weird and I have
Accepted records showing green. I double checked my syntax and all three are
identical. There is nothing in the data to warrant these anomalies. Where do
I look next?

"Mike H" wrote:

Hi,

select column c and apply these 3 conditional formats
=$B1="Accepted"
click Add
=$B1="Not accepted"
click add
=$B1="Cancelled"

I'm not sure about 'Hot Pink' though :)

Mike


"mdavison" wrote:

In Excel 2007, I want a column (C) to conditional color fill a cell if the
corresponding cell in (B) contains a certain word. I an't get the conditional
formatting to accept my IF statement. Should I be using a different function?

Example
B1 contains Accepted, C1 turns yellow
B1 contains Not Accepted, C1 turns green
B1 contains Cancelled, C1 turns hot pink
possibly others, but that's is the jist.

Thank you!

It was like 12 of 56 but I realized, I had not removed the manual fills the
person had added. I cleared all manual fills and Conditional rules, started
from scratch and everything is A-OK now.
Thanks so much!
-M

"Mike H" wrote:

hi,

what percentage isn't working and what is it doing?

mike

"mdavison" wrote:

Thanks Mike,
this one makes sense because obviously I don't want the row to be absolute.
But its not working 100%. I was making it WAY too complicated with an If
embeded. :)

But I have Cancelled items in Pink and Yellow which is weird and I have
Accepted records showing green. I double checked my syntax and all three are
identical. There is nothing in the data to warrant these anomalies. Where do
I look next?

"Mike H" wrote:

Hi,

select column c and apply these 3 conditional formats
=$B1="Accepted"
click Add
=$B1="Not accepted"
click add
=$B1="Cancelled"

I'm not sure about 'Hot Pink' though :)

Mike


"mdavison" wrote:

In Excel 2007, I want a column (C) to conditional color fill a cell if the
corresponding cell in (B) contains a certain word. I an't get the conditional
formatting to accept my IF statement. Should I be using a different function?

Example
B1 contains Accepted, C1 turns yellow
B1 contains Not Accepted, C1 turns green
B1 contains Cancelled, C1 turns hot pink
possibly others, but that's is the jist.

Thank you!