Celia has attended:
Excel Intermediate course
Conditional formatting
I would like to know how to highlight some negative numbers the same colour as some positive numbers. For example a minus bounce rate on a website would be a positive thing and I would need to highlight this field as black although other minus fields would be red.
RE: Conditional formatting
Hi Celia
Thanks for getting in touch. Conditional Formatting will only be applied to the cells you have selected. So if you only want certain cells to be formatted under certain rules, make sure they're selected.
You can then select a different range of cells and apply a completely different set of rules. The cells could be next door to each other but behaving very differently!
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
