I am trying to use Conditional Formatting to highlight cell values as follows:
<=30% - RED
>30% but <=69% - YELLOW
>69% - GREEN
I came across a THREAD that helped me solve the "<=30% - RED" using =(ABS(B$2-C2)/B$2)<=0.3 and ">69% - GREEN" using =(ABS(B$2-C2)/B$2)>=0.7
I can't figure out how to do the ">30% but <=69% - YELLOW". I could just leave it blank but that would be the easy way out.
So how do I write it so that =(ABS(B$2-C2)/B$2)>0.3 but less than 0.7 fills in yellow.
Attached is an example.
Bookmarks