Conditional Formatting with Multiple Conditions

guppie

New Member
Joined
Mar 13, 2006
Messages
7
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

MrExcel MVP
Joined
Aug 18, 2015
Messages
8,787
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

New Member
Joined
Mar 13, 2006
Messages
7
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!!!
 
Last edited:

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
8,787
Excel is an amazing tool, but there's a lot to learn about it!

Glad I could help! :cool:
 

Forum statistics

Threads
1,077,849
Messages
5,336,734
Members
399,100
Latest member
darcob

Some videos you may like

This Week's Hot Topics

Top