AUTOMATIC COLUMN TRACKING
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 1 2 3 4 5 (yellow) 8 9 10 11 12 WHEN 1 2 3 4 5 CHANGE THAT ROW SHOLUD TO YELLOW. Please Masters advice on what to do. Appreciate your time. it can be just one cell, column or new column added but the colour yellow should show on Thanks. |
All times are GMT +1. The time now is 09:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com