Conditional formatting with IF statements
Thanks you two this works wonderfully.
--
Eric
"Bob Phillips" wrote:
=AND(D1<"",ISNUMBER(MATCH(-D1,D:D,0)))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Eric D" wrote in message
...
Thanks Stefi, this works great but is there a way for it to not highlight
cells that are blank?
--
Eric
"Stefi" wrote:
Select column D and crate Conditional formatting with this formula:
=NOT(ISERROR(MATCH(-D1,D:D,0)))
Regards,
Stefi
"Eric D" ezt Ã*rta:
Is there a way that I can use conditional formatting with an IF
statement?
What I want to happen is, if in column D there appears a number that
has an
opposite match (i.e. 500 and -500) that it highlights those. Is this
possible and if so, how?
Thanks
--
Eric
|