Hi All,
I look for older posts,but could not find the solution to my problem. I have a cell that needs to turn Green or Red based on a Target. The target is 65.7%.
My cell that has conditional formatting, should be green because It hit the target of 65.7%, but it turns red.
my conditional formats are a follows:
Green: =AND(I33>=I32,I32<>"",I33<>"")
Red : =AND(I33<I32,I32<>"",I33<>"")
My Target is cell I32. Why does I33 turn Red? It should be green.
Thanks in advance.
I look for older posts,but could not find the solution to my problem. I have a cell that needs to turn Green or Red based on a Target. The target is 65.7%.
My cell that has conditional formatting, should be green because It hit the target of 65.7%, but it turns red.
my conditional formats are a follows:
Green: =AND(I33>=I32,I32<>"",I33<>"")
Red : =AND(I33<I32,I32<>"",I33<>"")
My Target is cell I32. Why does I33 turn Red? It should be green.
Thanks in advance.