Conditional Formatting Formula based on a word in another cell

[IainD]

I am trying to set up a conditional format formula, that changes the back ground colour of a cell based on the word in another cell.

If the day of the week in the cells in column A is "Saturday" or "Sunday" I would like the back ground colour in the cell in column B to change to red.

Is this possible & if so, does anyone know the formula code to do this?

Any help or assistance would be very much appreciated.

Kind regards,

Iain.

 

[njimack]

Like this?

Excel Workbook
	A	B
1	Monday	Weekend?
2	Tuesday	Weekend?
3	Wednesday	Weekend?
4	Thursday	Weekend?
5	Friday	Weekend?
6	Saturday	Weekend?
7	Sunday	Weekend?
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1	1. / Formula is =LEFT(A1)="S"	Abc
B2	1. / Formula is =LEFT(A1)="S"	Abc
B3	1. / Formula is =LEFT(A1)="S"	Abc
B4	1. / Formula is =LEFT(A1)="S"	Abc
B5	1. / Formula is =LEFT(A1)="S"	Abc
B6	1. / Formula is =LEFT(A1)="S"	Abc
B7	1. / Formula is =LEFT(A1)="S"	Abc