View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kanmi Kanmi is offline
external usenet poster
 
Posts: 76
Default 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.