I have a spreadsheet with datra in this range: A2:AD343. This range is growing one row at a time. The number of columns is static.
Example of what I need the worksheet to do automatically:
I have already input values into cells A4:AB4. This text is black by default and needs to stay that color until a date is entered into cell AC4. Entering a date into AC4 should cause the text in cells A4:AD4 change to (RGB = 0,176,80) a green color.
I am looking for VBA code for this to work.
Bookmarks