Conditional format formula with multiple conditions

Hi All,

I'm formatting row color based on the value of a cell within that. I have now so that if column "I" has a value of "W," the row is formatted green. However, I only want rows that have both "W" in column I and "FIA" in column H.

The formula I have is:
="($I6=""W"" AND $H6=""FIA"")"

But that's not working. Any suggestions?

Thanks in advance.

=and($i6="w",$h6="fia")

In Excel, the AND statement preceeds the arguments

Please Login or Register  to view this content.

Please Login or Register  to view this content.

ChemistB

Thanks! That works brilliantly!