Hi All,
I wish to colour a cell in a range if the contents meet certain criteria. I can use conditional formatting to do this, but in this instance I wish to use a formula within a macro.
Example:
Range P5:P20
Color cell Green if the contents equal 6.
Can do this by formula =if(P5=6,then color it green) and copy it down to P20.
Is there a better way to define my formula using my range in the formula rather than copying it down.
Probably a dumb question but can anyone suggest a better way.
Thanks
I wish to colour a cell in a range if the contents meet certain criteria. I can use conditional formatting to do this, but in this instance I wish to use a formula within a macro.
Example:
Range P5:P20
Color cell Green if the contents equal 6.
Can do this by formula =if(P5=6,then color it green) and copy it down to P20.
Is there a better way to define my formula using my range in the formula rather than copying it down.
Probably a dumb question but can anyone suggest a better way.
Thanks