Conditional Formatting Entire Row

[thewabbit]

Hi all

I am working on a spreadsheet which has a list of tasks for contractors to do and when each task is completed I add a 'tick' ('R' in wingdings 2) to a column B. I want each row (11 columns wide) to be highlighted a different color (say green) once the tick has been placed. I have tried many times to try and get this to work but it doesn't want to.....

If you could offer any help, it would be greatly appreciated

Thanks

 

[VoG]

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

 

[thewabbit]

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

Brilliant!! Thank you so much