I am trying to put an IF & AND function into Conditional Formating but I am
not getting the required result.

I am trying to express "If D7 = Yes AND D8=0 THEN Change Font in D8 to Red"

How would I express this in Conditional Formatting?


Thanks

Good question.
I don't think you can.
I think the IF has to refer to the cell itself.


"John" a écrit dans le message de news:
...
I am trying to put an IF & AND function into Conditional Formating but I am
not getting the required result.

I am trying to express "If D7 = Yes AND D8=0 THEN Change Font in D8 to
Red"

How would I express this in Conditional Formatting?


Thanks

No need for IF

=AND(D7="Yes",D8=0)

change the condition to formula is.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"John" wrote in message
...
I am trying to put an IF & AND function into Conditional Formating but I
am
not getting the required result.

I am trying to express "If D7 = Yes AND D8=0 THEN Change Font in D8 to
Red"

How would I express this in Conditional Formatting?


Thanks

Thanks Bob, I was trying to work the formula as you would a normal cell
formula, leaving the IF in





"Bob Phillips" wrote in message
...
No need for IF

=AND(D7="Yes",D8=0)

change the condition to formula is.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"John" wrote in message
...
I am trying to put an IF & AND function into Conditional Formating but I
am
not getting the required result.

I am trying to express "If D7 = Yes AND D8=0 THEN Change Font in D8 to
Red"

How would I express this in Conditional Formatting?


Thanks

In CF that is not necessary John, as CF just wants a TRUE or a FALSE. In
other words, the IF is implied, the formatting is the action.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"John" wrote in message
...
Thanks Bob, I was trying to work the formula as you would a normal cell
formula, leaving the IF in





"Bob Phillips" wrote in message
...
No need for IF

=AND(D7="Yes",D8=0)

change the condition to formula is.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"John" wrote in message
...
I am trying to put an IF & AND function into Conditional Formating but
I
am
not getting the required result.

I am trying to express "If D7 = Yes AND D8=0 THEN Change Font in D8 to
Red"

How would I express this in Conditional Formatting?


Thanks

Hi John,

Just write the formula into conditional formatting formula box of Cell
D8
=AND(D7="Yes",D8=0)

and do the formatting as you want


this will do the required thing

thanks

Shail

John wrote:
I am trying to put an IF & AND function into Conditional Formating but I am
not getting the required result.

I am trying to express "If D7 = Yes AND D8=0 THEN Change Font in D8 to Red"

How would I express this in Conditional Formatting?


Thanks