Hi J.E,
To take this one step further,
When rows are marked in a different color,
is there a way to move these rows to an existing worksheet, and just append
them to the worksheet?
--
---------------------------------------------------------------------
"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
"M Hill" wrote in message
...
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.