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.
|