Changing color in macro

[ecarney14]

Hey I am trying to use the If function to change the color of the cell in a macro, for instance.

If(Sheet1!A2>0, (show Sheet1!A2 in color), Sheet1!A2)

TO explain better, if a previous cell is higher than 0, make the new cell green, if not leave it the same as before.

I want this to show results better.

Any help will be great thanks!

 

[ecarney14]

Oh sorry,

I just used cell value is. The cell value was calculated using the formula i explained in the last post.

 

[ecarney14]

I used 3 conditions:

cell value is between .9 and .95 then green
cell value is between .95 and .99 then yellow
cell value is greater than or equal to .99 then red

 

[GlennUK]

In that case apply the Conditional Formatting to the entire range in one go.

 

[ecarney14]

Thanks so much!