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
Bookmarks