View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default Coloring a row a different color upon completing a cell

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.