Thanks J.E, appreciate your help, thank you.

--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com


"J.E. McGimpsey" wrote in message
...
Check out Conditional Formatting in XL Help.

one way:

Select the row(s) - say row 2 has the active cell

Choose Format/Conditional Formatting and change the dropdowns and
Textboxes to read

Formula is =(LOWER($D2)="y")

Click Format and choose a color from the patterns tab. click OK, OK.


In article ,
"M Hill" wrote:

HI guys, dont know where to start here.

I have 4 columns

Date Task Details Completed

What I would like to do is:
If I enter the letter 'y' in the Completed cell,
then the whole row changes color.

Any help greatly appreciated.