Highlight row any random color using same random color with duplic
Visual Basic 6.3/Excel 2003/XP
(Function Question 1) Column A- has many different ticket numbers sometimes duplicated. Can I create code to have all duplicated ticket numbers highlighted a random color? Then hightlight the entire row whatever color that is? For ex: I would like 1456 on both rows to be any random color that will continue from Column A to Column F. Column A Column B ... Column F 1456 NMS Work in Progress 1489 BO Scheduled 1456 Staffed New 1789 NMS Scheduled (Function Question 2) Column D has date and time. What code will color the entire row that matches date and time? For ex: 5/1/2008 9:00 make this entire row from 1456 (Column A) xColor & 1789 (Column A) That same color. Column A... Column D ... Column F 1456 5/1/2008 9:00 Work in Progress 1489 5/8/2008 19:00 Scheduled 1456 5/30/2008 3:00 New 1789 5/1/2008 9:00 Scheduled Thank you for your time.... -Altan |
All times are GMT +1. The time now is 03:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com