98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Adding 2 types of conditional formatting to the same cell?
Adding 2 types of conditional formatting to the same cell?
Resolved · High Priority · Version 2016
Lauren has attended:
Excel Intermediate course
Excel Intermediate course
Adding 2 types of conditional formatting to the same cell?
I have an Excel sheet which I want to show in 2 columns the date we sent out the "MOS" and the date we received "Docs from Solicitor". In the "MOS" column, I want to add a colour scale conditional formatting formula, like a timer, that changes colour based on the date. So green for between the date entered up to +2 days. Yellow for +3 days up to +4 days and red for +5 days and over.
However, in the "Docs from Solicitor" column, which is next to it, I'd like to be able to add a second date, which stops the timer on the "MOS" column and sets it, so that colour remains the same once the second date in entered.
There is a 3rd column for "days between MOS and docs" which I have already added a colour scale and shows the amount of days in between column "MOS" & column "Docs from solicitor". (I don't know if this would affect any of the above?)
I've been asked to have this done by the end of the week if possible, so any help would be great.
Many thanks,
Lauren
RE: Adding 2 types of conditional formatting to the same cell?
Hi Lauren,
Thank you for the forum question.
I hope I have understood what you want.
Please find attached file and have a look at my rules.
I hope it makes sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
RE: Adding 2 types of conditional formatting to the same cell?
Hi,
Many thanks for getting back to me, but I cant seem to find the attachment?
Please can you resend?
Many thanks,
Lauren
RE: Adding 2 types of conditional formatting to the same cell?
Hi Lauren,
It happens from time to time.
Please go back in to the forum post and refresh your browser.
Please let me know if you still cannot see it.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shared Conditional FormattingIn a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones. |