Forum Discussion
Using IFBLANK with IF Formulas
Yes:
=IF(F1="", "", IF(F1="Standard", ..., IF(F1="Full", ...)))
or
=IFS(F1="", "", F1="Standard", ..., F1="Full", ...)
=IFS($C$18:$C$517,"Standard",$G$18:$G$517,">="&DATE($Q$6,$R$6,$S$6),$G$18:$G$517,"<="&DATE($Q$7,$R$7,$S$7))
I'm trying to format (fill) the cells in the workbook that are within the category (standard or full) and within the date range so they're easier to identify. Thanks!
Select the range you want to format. The active cell in the selection should be in row 18.
On the home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND($C18="Standard",$G18>=DATE($Q$6,$R$6,$S$6),$G18<=DATE($Q$7,$R$7,$S$7))
Note that there is no $ before the row number 18. We want this to be relative.
Click Format...
Activate the fill tab.
Select a color.
Click OK, then click OK again.
Activate the Fill tab
If you wish, you might like my replies by clicking the thumbs up button, and if the forum allows you to mark more than one reply as the solution, do that. But it's not essential, your kind words are reward enough!
- Hans, BRILLIANT! That was it. I've duplicated the formula for each of my columns so the relative measurements were adjusted appropriately. Impossible for me to thank you enough. How may I give a positive review or endorsement? What would be helpful?