I have a fx in H10. In J10 is where my formatting is to take place.
the C/F is as follows in J10: =H12>0
Once it changes to a value >0, I want the cell to change to a color.
But I don't want the color to show until there's a value in H.
Right now the cell will still be "green" because it sees the fx as a valule..
How can I fix that
the C/F is as follows in J10: =H12>0
Once it changes to a value >0, I want the cell to change to a color.
But I don't want the color to show until there's a value in H.
Right now the cell will still be "green" because it sees the fx as a valule..
How can I fix that