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|
- It gets worse ! 335 2
- PCTR for Audit Qualification 85 1
- Building premises bought on 99 year lease 74 1
- Client refusing to change basis period 181 6
- Companies House Authentication code 200 9
- Increasing the personal allowance: A top priority? 1,978 66
- Is an apprenticship classed as another job for PAYE RTI rules 174 2
- RBS asking client to switch accountant 459 8
- VAT on converting Commercial property to residential 52 2
- Payroll Software Recommendations 304 10
- P60 Plain Paper from Sage Payroll 343 15
- saturday staff 407 4
- Sports Club - Option to tax 50 1
- Highlighting a line on cell click 63 4
- Looking for free PDF creator 1,448 42
- Moving from Moneysoft to another payroll product 522 12
- Free accounts system for small business? 363 6
- Suppliers for Online Card Payments? 647 15
- Rights of Alphabet shares 350 13
- Multiple bodies and practicing certificates 262 3
- Xtuple 586
- Qtac payroll for bureau 411
- Confused - Professional Association a Mutual trader, or not? 356
- Director legal fees in loose connection to the company 229
- Tax on damages received 210
- Accounts consolidation spreadsheet 173
- Temporary non residence and CGT on non-UK asset 165
- PTP Software 157
- Accounting for commercial lease with break clause 141
- Software for Belgium Company 140