kellyfamily
New Member
- Joined
- May 22, 2017
- Messages
- 5
Apologies if this has been covered but i couldn't the answer i was looking for.
I have a spreadsheet with the following headings
<tbody>
</tbody>
I am currently using the following formula under the Status heading: =IF(K21="",IF(I21<TODAY(),"UNSERVED","Pending"),"Served"), if i drag the formula down the column and do not have an expiry date status is unserved in the blank cells, how can i fix it so it remains blank until data is entered in the expiry date column, i also would like Unserved, pending and served to be different colours.
Thanks
I have a spreadsheet with the following headings
Effective Date | Expiry Date | Status | Date served |
<tbody>
</tbody>
I am currently using the following formula under the Status heading: =IF(K21="",IF(I21<TODAY(),"UNSERVED","Pending"),"Served"), if i drag the formula down the column and do not have an expiry date status is unserved in the blank cells, how can i fix it so it remains blank until data is entered in the expiry date column, i also would like Unserved, pending and served to be different colours.
Thanks