Conditional Formatting across sheets Jun 20, 2012
How to perform a conditional format that needs to look at a different sheet.
Home // Blog & Excel Tips // 77
Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Request info on training dates, prices and venue
AND and OR functions Jun 20, 2012
The question is a bit unclear but from what we see you should be using the AND and OR commands. See how to use them on https://www.auditexcel.co.za/AND_OR.html . Hope this helps, otherwise it is better to send a spreadsheet.
Pulling every 17th cell into a consecutive list Jun 20, 2012
How to pull every xth cell into a consecutive list using the OFFSET function
Consulting
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
Live Training
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."
Free Excel Tips & Tricks delivered straight to your mailbox. Sign up today.