Hi All - first post :-)
Can anyone advise me of a way to highlight selected cells if one of the selected cells equals a certain value eg

A B C D E
1 X X X Y X
2 X X X X X
3 X X X Y X

I select cells A1-E3 and if column D = "Y" then colour fill the row from A to E

Thanks

Mike