Attempting to highlight a cell if it falls between a low number and a high number. My conditional format formula is currently IF(AND($D$24>0,$D$24<$F$24). This formula returns a dialogue box stating "missing a parentheses. Currently Cell D24 is 50,000 and Cell F24 is 100,000. I wish for cell F24 to be highlighted because D24 is more than 0 but less than 100,000.
Thank you for your consideration
Bookmarks