Availability Spreadsheet - I can't get the row to change colour multiple conditions

Hi All,

An absolute laymen here - I've been trialling and erring trying to sort out a home made calendar of people's availability and it doesn't do what I would like - I have figured out some elements (thanks to online searches).

I am building an availability spreadsheet that covers up to a year in advance - where I'd like the colour to change as details are entered - below is where I am up to.

*
Saturday/Sunday
Basically I've figured out (perhaps stumbled...) how to Bold and highlight a row in grey if "Sunday" exists:*
=SEARCH("Sunday", $A2)>0
apply to:*$A$2:$G$33
*
and another formula for Saturday which also bolds and highlights the row in grey:
=SEARCH("Saturday", $A2)>0
apply to:*$A$2:$G$33

Family Holiday
=COUNTIF($G2,"*Family Holiday*")>0
apply to:*$A$2:$G$33

People have indicated they?re busy:
=COUNTIF($C2:$F2,"*xx*")>0


HERE IS WHERE I NEED HELP

Now I would like to create another rule that basically says:

If any of the following cells C2, D2, E2 or F2 contain "*xx*" (eg somebody is busy)
AND
G2 contains "Family Holiday" then apply chosen formatting (in my case colour A2:F2 in yellow.

I?ve tried the following (and many variations....which just proves I don't know what I am doing):
=AND(($G2,"*Family Holiday*")>0,($C2:$F2,"*xx*")>0)

I don?t seem to be making any headway into solving this puzzle!

Any assistance would be much appreciated.

I'll move it. But....

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

I believe that if you replace the first conditional formatting rule (yellow) with the following it will do what you want:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.