I have a worksheet to which I have added conditional formatting to change the colour of cells if another cell on that row contains data. I started with just 3 or 4 rules, but as I have added more rows of data, the rules have expanded (by themselves!) to around 50 rules. How can I add more rows of data without increasing the number of rules?
Hi! I have a great experience in Excel, so it will be easy for me to complete your project. Just send me your file and you'll receive perfect Excel spreadsheet.