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
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
