VBA: Check values in sheet

[Jefferson]

Using VBA, I have values in range("A1:Z1"). Is it possible to check value of each cell? Like when any cell in the range has value more than 60, it changes font color to green.

 

[Brianwarnock]

Check out conditional formatting either in help or google it.

Brian

 

[Brianwarnock]

Read your post again and although I don't understand fully what you mean I presume that you are writing the values in VBA code, in which case you can set the cell colour , I think it's called interior color, depending on the value you are writing.

Brian

 

[Jefferson]

Thanks for reply. I already found out how to do it.

 

[Brianwarnock]

That's good , it's always better if you can do things yourself.

Brian