Conditional Formatting with Multiple Conditions

[guppie]

I am trying to do some conditional formatting based upon 2 conditions.

I have a column (S) that contains a number.
I have a column (G) that contains a Y or N.

I would like to highlight any cells in column G where it contains a "Y" and where column S in the same row contains the number 1.

I clicked on the entire column G and selected Conditional Formatting. I created a new rule, chose the formatting that I wanted and used the following rule:

=AND($S$S=1,$G$G="Y")

This does not seem to be working. Any help would be appreciated.

 

[Eric W]

Click on column G and use this rule:

=AND(G1="Y",S1=1)

The references in the formula should refer to the upper left cell of the range selected.

 

[guppie]

Wow. That worked. Thanks a lot. I thought I had to use $g:$g to represent the entire column. I love using excel but have a long way to go!!!

 

[Eric W]

Excel is an amazing tool, but there's a lot to learn about it!

Glad I could help!