Excel help - urgent - pleeease NEW query on this
I'm really stuck on this, and my laptop doesn't seem to be doing what Excel help pages on the web said it should be???
Anyway, 3 columns below - D, E, and F
Orig spreadsheet just had Issue Date and Response Deadline. I have been asked to make Response Deadline turn the cell Red or Green depending on whether the date in Response Deadline is more than 10 days after Issue Date, ie day 11 onwards is Red. So, I added the middle column which calculates the number of days between the issue date and the response (received!!). I am going to 'hide' the middle column when it's done. I have tried everything I can to make the cells in column F turn Red or Green but I don't seem to be getting a proper menu for my conditional formatting. I have Windows 7 (which is awful). I get given a set of pre-written options when I click on Conditional Formatting.
I've been asked to do this as a favour for someone who is under the kosh and needs it by 5.30pm tonight. Editt: tomorrow am now!
I've been playing around with it and think I know what's needed. Can I do a formula that calculated the number of days from the Issue Date to 'Today'? If so, I can amend my columns and do conditional formatting for the result of that new formula.
Can anyone help me please???
|Issue Date||Response Deadline|
- General tax book with planning 148 2
- Limited Company - Personal Bank Account 3,206 69
- 2013/14 failure to submit end of year submission 284 11
- Gift of property & improvements 118 2
- Error in past Corporate tax return 342 5
- VAT Invoice 137 4
- Company overdue but wants to be struck off 805 32
- IHT and Swiss Property 129 1
- Sale of house with planning permission - tax free? 218 3
- Flat rate Vat Scheme & Vat on wholesale production of Cakes and other deserts 186 7
- Vat code for journal entries of director's expenses 153 2
- Claiming VAT and missing receipts 452 10
- HMRC overreaching its powers -again against a small surveying firm? 375 8
- Help with tax codes on Sage 257 1
- Letting relief on property transferred to a spouse 186 6
- VAT code for invoice from not VAT registered company 258 4
- Accounting for a finance lease 165 4
- SA302's anyone?? 538 16
- A change from the old Q v NQ debate 1,644 41
- Renting for military reasons 195 2
- Skandia using wrong address 1,620
- Nil Rate Band Trust - index linked debt by way of charge over property 901
- International interest certificate 511
- NOVA 368
- Have we escaped Gift with Reservation of Benfit & Pre-owned asset charges? - Gift after benefit 297
- Management expenses for investment company 263
- Bonus Bonds 261
- Entertainer withholding tax in Australia 173
- tax on apprenticeship income 173
- P11D benefit received by widow 149