Hello,
would it be possible to change the color of a segment of a row (say A1:A10) depending on a number located in the first cell of the row (A1). So if A1 has the number 2 in it, I would like the rows A1:A10 to have the text red.
But the number 2 could also be in the cell C1 and C1:C10 would also need to be red.
I suppose this is possible with a macro, but unfortunetly, I do not know how to code VBA.
If anyone could help me, I would greatly appreciate it,
Julian
would it be possible to change the color of a segment of a row (say A1:A10) depending on a number located in the first cell of the row (A1). So if A1 has the number 2 in it, I would like the rows A1:A10 to have the text red.
But the number 2 could also be in the cell C1 and C1:C10 would also need to be red.
I suppose this is possible with a macro, but unfortunetly, I do not know how to code VBA.
If anyone could help me, I would greatly appreciate it,
Julian