Forum Discussion
Solved
formula and formatting help
Hey everyone, so I need help with a formula. In the sheet attached I have "INSTR QUAL STATUS" cell (F15) and I tried using a IF AND Function but couldn't get it to work for me. what I'm trying to d...
Change the formula to
=IF(COUNTBLANK(Table1[@[INSTR. QUAL. TYPE / LEVEL:]:[INSTR. QUAL. EXP. DATE:]]),"",IF([@[INSTR. QUAL. EXP. DATE:]]<TODAY(),"Expired","Active"))
ya I have tried flipping the order but still didn't work.
Did you look at the version that I attached?
Could you attach a workbook with the non-working rules? The one you attached to your previous reply was the same as the first one...
- I thought I tried it that way but I probably didn't. thank you Hans. Again I really appreciate it
You used OR instead of IF in the formula for yellow. If you change OR to AND, it'll work as intended:
See the attached version.
i apologize here it is