So tell me. When you double click on what cell?
You want that cells background color to be what color say like red blue green yellow
And enter todays date in what cell.
I need you to say something like this:
When I double click on any cell in column B to turn that cells background color to yellow and put todays date in column A
Do not say when I double click on column address.
When i double click on any cell on columns G, H, or I, turn that cell blue and insert todays date and time in to that same cell.