Hello,
I'm completely new to VBA
i'm trying to get a set of indicators at the first available column in every sheet that the workbook contains.
the column that is used for the verification is in percentage
I have tried it with the macro recorder and several other things but I can't get it right
the number of columns for each sheet is the same
<tbody>
</tbody>
50% = good
10% = warning
5% = red
Can someone help me here?
Rgds,
John
I'm completely new to VBA
i'm trying to get a set of indicators at the first available column in every sheet that the workbook contains.
the column that is used for the verification is in percentage
I have tried it with the macro recorder and several other things but I can't get it right
the number of columns for each sheet is the same
text | text | text | 50 | 25 | 50% | 50% |
text | text | text | 50 | 40 | 90% | 10% |
text | text | 20 | 50 | 45 | 95% | 5% |
<tbody>
</tbody>
50% = good
10% = warning
5% = red
Can someone help me here?
Rgds,
John