Conditional formatting question

[hwass]

Hello!

I have two columns in an excel spreadsheet, column A containing the day of the week (Tue) and column B containing the date (in the format 22/02). I have used conditional formatting to highlight the cell of every "Sat" in yellow. I would also like to highlight the cell on the same row in column B, can anyone help??

 

[VoG]

Hi. This should help http://www.contextures.com/xlCondFormat02.html

 

[hwass]

Many thanks for your help it worked wonders