Forum Discussion
Help with Conditional formatting
Lindsay,
It looks like the format painter was still referencing column A, and the last two were missing the <. I've corrected the formulas, and also added a rule to handle blank cells. I've taken the liberty of adding a sheet to your workbook, and copying your info to a table. This is an instance that I would recommend using a table for your data, because the conditional formatting 'Applies to' section will grow and shrink as rows are added and removed. If you press tab in the bottom right cell of the table, it will automatically add a new row, and extend the formatting, and any column formulas you may use to the next row. Just something to consider, and if you decide not to use it, you can just delete the tab that says Table Version
Hi,
Thank you for your response, but it does not seem to work for me. I have attached the spreadsheet minus all the other information in it other than the dates. This is after I copied and pasted the format.
Lindsay,
It looks like the format painter was still referencing column A, and the last two were missing the <. I've corrected the formulas, and also added a rule to handle blank cells. I've taken the liberty of adding a sheet to your workbook, and copying your info to a table. This is an instance that I would recommend using a table for your data, because the conditional formatting 'Applies to' section will grow and shrink as rows are added and removed. If you press tab in the bottom right cell of the table, it will automatically add a new row, and extend the formatting, and any column formulas you may use to the next row. Just something to consider, and if you decide not to use it, you can just delete the tab that says Table Version
Thank you for your help Bob! This worked perfectly! Could you please tell me where to go if I needed to change the days from 20 to 15 for example? or If I wanted to add another rule. There are so many options to choose from... I'm good with excel but apparently not that good lol
If you select the column, and click Conditional Formatting, then Manage Rules. You should see the rules there, and can edit one or more of them. Keep in mind, that Excel checks each one in the order that they appear, and if the Stop If True box is checked, it stops there.