Conditional Formatting with multiple rules

Hi,

I'm trying to use conditional formatting to flag an entire row based on the values in two cells in different columns.
Based on the value in column F (Y or N) I can get the row to be flagged as red or green respectively by using the INDIRECT function.
What I want to do is to flag the row as a different colour if the value in column F=Y and the value in column G=N. The only way I can figure out how to do this will also change the row colour even if column F=N which isn't what I want.
Basically I want the row colour to be dependent on values in both F and G rather than independent.

Any help will be greatly appreciated!

This doesn't seem to work as I am trying to apply the formatting to the entire row, not just a single cell.

Martin is nearly spot on, you want to use the formula =AND($F1="y",$G1="n") in your conditional formatting. In this way Excel will increment the row, but not the column, so you can apply this conditional formatting to an entire row with it still looking in columns F and G.

That's working now, thanks for the help!

What I had with the indirect function was:

=INDIRECT("F"&ROW())="N"