If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
COLOUR MANAGEMENT
I WANT TO SET COLOUR ON A WORKSHEET THAT WHEN I CHANGE CONTENTS ON THE ROW
WITHIN 2DAY THE COLOUR OF THAT ROW SHOULD SHOW YELLOW "SET FOR "2DAYS" AFTER THESE DAYS THEN RETURN AS OTHERS ROWS. for example. A B C D E F 1 2 3 4 5 7 8 9 10 11 12 13 WHEN 1 2 3 4 5 7 CHANGE THAT ROW SHOLUD TO YELLOW. Please Masters advice on what to do. Appreciate your time. Thanks. |
#2
|
|||
|
|||
COLOUR MANAGEMENT
Hi,
Do the contents of a single cell on the row need to change or do all the cells contents need to change. You will need to use VBA programming to do it, regardless of the answer to the above. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Kanmi" wrote: I WANT TO SET COLOUR ON A WORKSHEET THAT WHEN I CHANGE CONTENTS ON THE ROW WITHIN 2DAY THE COLOUR OF THAT ROW SHOULD SHOW YELLOW "SET FOR "2DAYS" AFTER THESE DAYS THEN RETURN AS OTHERS ROWS. for example. A B C D E F 1 2 3 4 5 7 8 9 10 11 12 13 WHEN 1 2 3 4 5 7 CHANGE THAT ROW SHOLUD TO YELLOW. Please Masters advice on what to do. Appreciate your time. Thanks. |
#3
|
|||
|
|||
COLOUR MANAGEMENT
Both can be change and new column can be added to the page. Please give me
VBA SCRIPT and explain how to use it. Thanks and appreciate your time. "Shane Devenshire" wrote: Hi, Do the contents of a single cell on the row need to change or do all the cells contents need to change. You will need to use VBA programming to do it, regardless of the answer to the above. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Kanmi" wrote: I WANT TO SET COLOUR ON A WORKSHEET THAT WHEN I CHANGE CONTENTS ON THE ROW WITHIN 2DAY THE COLOUR OF THAT ROW SHOULD SHOW YELLOW "SET FOR "2DAYS" AFTER THESE DAYS THEN RETURN AS OTHERS ROWS. for example. A B C D E F 1 2 3 4 5 7 8 9 10 11 12 13 WHEN 1 2 3 4 5 7 CHANGE THAT ROW SHOLUD TO YELLOW. Please Masters advice on what to do. Appreciate your time. Thanks. |
Thread Tools | |
Display Modes | |
|
|