I have tried and tried and can only get one conditon to work and that is the first one. I have all text in the spreadsheet there are no numbers.
Examples would be
Column A Column C
NED NED Match color would be green
NED CLE no match color would be blue
NED Column c is blank color would be red



I am using 2007, Conditonal formatting, Manage Rules, New rules.

= Exact (A5,C5) format Green
=If Column A <> Column C format Blue
=If Column B isblank format Red

I am looking to highlight the entire row if possible and have these conditions for the entire sheet.

Thank you.
Laurie B.