Hi there.
I am trying to make a certain range of cell (A1:C5) turn to red/white according to the value of A in each row using VBA
by clicking on a button to check and change it.
<colgroup><col width="64" style="width:48pt"> <col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Rule: If the Value of A is not a number then turn the color of the row to Red/white.
In this case:
Range A3:C3 and range A4:C4 in red/white color.
Thanks,
Dave
I am trying to make a certain range of cell (A1:C5) turn to red/white according to the value of A in each row using VBA
by clicking on a button to check and change it.
A | B | C |
1 | Dog | 200 |
5 | Pig | 50 |
R1 | Dog | 10 |
F1 | Dog | 5 |
8 | Pig | 2 |
<colgroup><col width="64" style="width:48pt"> <col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Rule: If the Value of A is not a number then turn the color of the row to Red/white.
In this case:
Range A3:C3 and range A4:C4 in red/white color.
Thanks,
Dave