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!
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!