I'm trying to figure out the conditional formatting formula to use for the following:
If cell A1 is >0.7 format the cell green
If cell A1 is <0.7 format the cell red
If cell is 0, no formatting no color
What I'm using now will format the cell green when you have a zero and green if you iferror the cell. Any help would be appreciated.
Thanks.
Bookmarks