| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Entire Rows depending on Text in Column A
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Delete entire rows by selecting different text in column A | Excel Discussion (Misc queries) | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
| CONTIF DEPENDING ON TEXT/NUMBER COLOR | Excel Discussion (Misc queries) | |||
| problem not solved... CONT.IF depending on the text color | Excel Discussion (Misc queries) | |||
| Changing cell or text color depending on week number | Excel Discussion (Misc queries) | |||
Threaded Mode
