Conditionally format column based on 2 other columns

[honkin]

I need to conditionally format a column based on the text in 2 other columns and am just wondering what the best way to reference the entire columns in my formula would be

Here is the code as it stands

=AND(A1="MARIA1",C1="PORTUGAL: Segunda Liga")

So if I wanted it to apply to all of A and all of C, would I just change it to be A:A and C:C? I didn't want to use C2:C1048576 if possible. The CF will then highlight entries in E, so I assume I would have the range as E:E

And I guess if I want those same columns to look for different text, I would need a different rule for each condition yeah? As an example, a cell in A might have MARIA10 and a cell in C might have Italy: Serie A and so on

cheers

 

[honkin]

cheers Fluff. Happy to do that, but it is exactly what the original post was about; conditionally formatting one cell (E) based on the contents of others (A & C).

Will repost now.