What symbols do you use to create a formula is formula for between. I need to shade some cells based on the following:
I have a beginning and ending week number in columns D and E. I want the cell to shade when the week number is between the two nyumbers.
If k1 equal to or greater than d2 but equal to or less than e2 then shade the cell.
Thanks
I have a beginning and ending week number in columns D and E. I want the cell to shade when the week number is between the two nyumbers.
If k1 equal to or greater than d2 but equal to or less than e2 then shade the cell.
Thanks