HELP!! I can't figure this one out.
First condition works: =INDIRECT("AF"&ROW())<17% - The row shows red
Second condition does not work: =AND(INDIRECT("AF"&ROW())>16.9%,INDIRECT("AF"&ROW())<20%) - Should show yellow but does not
Third condition works: =INDIRECT("AF"&ROW())>20% - The row shows green
Does anyone know what I've done wrong in the 2nd condition. I need it to highlight the entire row if AF is between 17.0% and 19.9%. Thank you.
Bookmarks