Issue Number 1: I have a task list that I am trying to set up an auto number VBA code for. I have a header row in my work sheet and i would like that to be excluded from the count or auto number. I have already figured out how to do auto date and time entry but I am struggling with auto number. Can someone please help? I have pasted the code I currently have below as well as a listing of the column headers for reference.
Row 1 - Headings
Column A - ID# (Auto)
Column B - Date (Auto)
Column C - Time (Auto)
Column D - Issue (Manual Entry)
Column E - Responsible Party (Manual Entry)
Column F - Actions Taken (Manual Entry)
Column G - Status (Dropdown List)
Column H - Cost (Manual Entry)
Issue Number 2: I currently have the Status column set up with conditional formatting so that the 3 different options appear as different colors (Open=Red, In Progress=Yellow and Closed=Black). This however only changes the color the single cell of column G. I would like to have it color the ENTIRE row and change when the value in column G changes. Is this possible? If so how?
Thanks in advance
Bookmarks