98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Conditional Formatting multiple rows on multiple conditions
Conditional Formatting multiple rows on multiple conditions
Resolved · Low Priority · Version 2007
Tue 5 Mar 2013, 11:55Delegate Nicholas said...
Nicholas has attended:
Excel VBA Intro Intermediate course
Conditional Formatting multiple rows on multiple conditions
Hello
I need to be able apply a conditional formatting to values in a row based on a specific value in a seperate cell. Each row requires formatting for a different cell.
I know this is possible in conditional formatting, but this is a large sheet and would be easier to do in code. However, i have tried and made a mess of it.
Can anyone help?
thanks
Nick
Tue 5 Mar 2013, 17:46Trainer Gary said...
RE: Conditional Formatting multiple rows on multiple conditions
Hi Nick
Thanks for getting in touch. This should be possible with an IF function and modifying cell properties.
What are the conditions, and what formatting do you require?
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best 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:
|
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:Shortcut for deleting all comments in a spreadsheetIf you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by: |
