Color Entire Rows depending on Text in Column A
Thanks to u and McGimpsey.
U people are really a great help
Rashid
"Bob Phillips" wrote in message
...
Conditional formatting will work if you select the whole row and use a
formula like
=$A1="Reject"
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Rashid Khan" wrote in message
...
Hello All,
I am using Office 2000 and have the following problem
A B C D .... .... ....
Fit Sam William etc ....
Reject Harry Jones etc ....
Active Bob Howe etc. ...
...
....
Fit ... ... .... .....
Fit
Active
Active
Reject
etc
I wish to put a commandbutton on the worksheet when clicked all Rows
depending upon the text in Column A (eg Fit should be green color, Reject
should be Red color, and Active should be Yellow color )
I tried conditional formatting but it just changes the cell and not the
entire row.. I wish to change the color of the entire row.
Can somebody please help me out
TIA
Rashid
|