Get instant live expert help on I need help with excel highlight blank cells
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I am trying to highlight blank cells that are past a certain time using conditional formatting
Solved by T. H. in 11 mins
I want to highlight all cells in the Middle name column that are blank, or have only an initial.
Solved by T. C. in 25 mins
I am experiencing a new glitch in excel where using conditional formatting the cells that are blank are registering as a 0 and will highlight, even if I include a format that says all blank cells have no formatting it still doesn't change. I have used the same conditional formatting previously and it does not do this.
Solved by E. E. in 19 mins
I need to use this formula: =O2<TODAY()-30 but have it only apply to blank cells. For example, I want P2 to highlight if the date in O2 is more than 30 days old (formula above) but ONLY highlight if P2 is blank. If P2 is not blank, it does not need to be highlighted
Solved by E. S. in 12 mins
i need a formula to highlight the cells, i will enter the total value excel should highlight the cells which sum equals to that value
Solved by K. S. in 11 mins