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
pls see attached sample.
hope it will work for you.
thanks..
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.
Mr. Orrell had corrected the formula - it should refer to column E where your dates are...
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
- the dates in column A is referenced to 9-26-2018 (today) - the resulting difference of day may change per actual data entered..
