Colour Row with Conditional Formatting

**trhorsley** · 08-22-2011, 01:04 PM

Hi I would like to be able to colour a row based on a word with a cell in that row. ie in a row if one of the words I type in is PAID then the whole row would turn Green. I am using Excel 2003 and none of the MS online help seems to cover anything other than colouring two rows or cells etc.
Look forward to receving your help, Many thanks
TH

**NBVC** · 08-22-2011, 01:09 PM

Is it just the work "Paid" that would go in that cell? Is it only one column that you are entering/checking for "Paid"?

**trhorsley** · 08-23-2011, 05:04 AM

Hi Sorry for the delay. It will be only one column which the word will go into but it will be 2 or 3 different words. So depending on the word it will change the row to a different colour.
Thanks

**NBVC** · 08-23-2011, 07:41 AM

Select the range you want to affect, and go to Format|Conditional Formatting

Select Formula Is from drop down menu and enter formula:

=$A1="Paid"

where A1 is the top most cell in your selection of the column that can have the word in it.

Click Format and choose from the Pattern tab.