Forum Discussion
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 do is have it say Active or Expired but only if there is data entered in either B16-E16 cell. if there is no data entered in any of those cells I want F16 to be blank.
Also you will see some conditional formatting in cell E16. I want the conditional formatting to work only if there is data entered in it. if its blank I want it to remain white.
thank you for any and all help.
Change the formula to
=IF(COUNTBLANK(Table1[@[INSTR. QUAL. TYPE / LEVEL:]:[INSTR. QUAL. EXP. DATE:]]),"",IF([@[INSTR. QUAL. EXP. DATE:]]<TODAY(),"Expired","Active"))
12 Replies
Change the formula to
=IF(COUNTBLANK(Table1[@[INSTR. QUAL. TYPE / LEVEL:]:[INSTR. QUAL. EXP. DATE:]]),"",IF([@[INSTR. QUAL. EXP. DATE:]]<TODAY(),"Expired","Active"))
- Thank you Hans! would you happen to know how to fix that conditional formatting issue im having as well?
Select the cell.
On the Home tab of the ribbon, click Conditional Formatting > Manage Rules...
Click Edit Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND(E16<>"",E16<TODAY())
Click OK, then click OK again.
