Forum Discussion
Conditional Formatting Blank Cells
I am needing a rule that will allow me to highlight blank cells yellow if they are less than 30 days from the date in Column A. Then change to red if it goes past the 30 day mark, until data is ente...
Thank you for the response. I highlighted the columns that I need the formulas applied to, and have built the rules as shown and it does not appear to be doing it correctly for me.
Please attach a sample workbook demonstrating the problem, or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar.
HansVogelaar hopefully this link works correctly.
https://docs.google.com/spreadsheets/d/1YJnQT9QHk9jX5sCkaDzM_bn1UQ5jrSgS/edit?usp=sharing&ouid=100103939138852560324&rtpof=true&sd=true
Your sample workbook doesn't contain ANY conditional formatting rule, so it's impossible to tell why it didn't work for you...
I have attached the workbook with the two rules that I proposed.
- Thank you so much for your assistance. I recreated what you did and after some trial and error got it to work.