AUTOMATIC COLUMN TRACKING

K

Kanmi

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top