Let me see if I can explain this. I need my cell(B6) to do different things depending on a series of questions. If B5 contains "double roll" AND B6 is less than 12 then it needs to turn red, but if B5 contains "double roll" and B6 is 12 or more than it needs to turn green. I don't know how to do this with the =IF(AND) function AND conditional formatting. Please help!!!
Bookmarks