PDA

View Full Version : [SOLVED] Color cells from previous colored cells in different column



PedroT
02-05-2018, 02:32 PM
I'm building a macro that colors cells in a column based on a criteria (in this case, if its value is < 10). I've done that part, but now I want all cells in the same row as those colored, but on the column A, to be colored as well. I can't use an offset function since the column with the values is variable (it searches for todays date). Basically, I want to make a selection of the cells in the column that has the current day date and are valued less than 10, "copy" that selection to the column A and color those cells as well.

Does anyone know how to do this, or could give me a hint? Would be very appreciated :)