Get instant live Excel expert help to learn how to apply conditional formatting to blank cells

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

We are creating a new customer classification system to focus on our largest customers. Our biggest customers are going to be called “Gold” class customers and the next group will be called “Silver” class customers: “Gold” class customers are those whose average monthly sales for the last twelve months are $7,000 and greater or the average previous quarter sales are $7,000 and greater. “Silver” class customers are those whose average monthly sales for the last twelve months are between $2,000 and $7,000 or the average previous quarter sales are between $2,000 and $7,000. Add a column next to the average monthly sales on the AR Aging sheet called “class” and make the word “Gold”, “Silver”, or blank appear as explained above. HINT: Do not try to do this step with Conditional Formatting. Now format these three columns: (1) Customer #, (2) the Customer Name, and (3) Class. Format all of these columns with gold fill and white font for the "Gold" class customers, and silver fill and white font for the “Silver” class customers. On the aging report, add our company’s logo (your choice of an appropriate logo), put a useful title on the report, add a freeze pane, and follow all Standards of Professionalism (only for the AR Aging report). The Standards of Professionalism are described in this list . You can also review this video tutorial to watch an explanation of the Standards of Professionalism.
Solved by B. D. in 12 mins
Conditional formatting Comparing dates in two columns, need the date to remain black if completed ahead of schedule, this conflicts with the late rule as blank cells are considered and earlier date.
Solved by C. F. in 28 mins
I want to use conditional formatting using the New Rule> Use a formula to determine... The company is in column A. In the columns R to AB are locations where there may or may not be offices of the company in A. If there is an office, it is marked with a '1'. No office is a blank field. I want to highlight in green (column A) any companies where there are three or more office locations noted in R to AB. It should be applied to the whole workbook.
Solved by S. H. in 20 mins
I am experiencing a new glitch in excel that conditional formatting blank cells 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 wrote a conditional formating formula =$M11:$M432 that formats in yellow, and applies to =$A$11:$L$11, which works successfully. The issue is I need to highlight the rows yellow down to Row 432 when Column M is not blank. How should I edit the rule to make each row auto highlight when M has an entry per individual row - Conditional Formatting Rules Manager Excel 2016?
Solved by E. H. in 30 mins
Trying to write a formula in conditional formatting to highlight when column N had "Stock" entered into it and column R in not blank. Currently using AND(NOT(ISBLANK($R4))) To change colour when a date is entered in column R, which works fine. Trying to add $N4="STOCK" but have drawn a blank with IF, AND, OR which ever way I try to nest it. Help!!
Solved by E. W. in 30 mins
Solved by X. W. in 16 mins
1. I have some conditional formatting rules set for the pivot table“Cycle Time”. Whenever the pivot table auto refreshes the conditional formatting is lost. Applying rule to entire column doesn’t work and the formula changes on its own. 2. On the sheet named “Individual Rep Productivity” filtered cells have been marked “remove blanks” under the drop down in A1. Formulas on this sheet pull from other sheets. Blank cells that are filled and later times and will populate. I would like for this to automatically update without having to check the box next to blanks and then uncheck it again for the new data to show up.
Solved by O. Y. in 22 mins
I hope I explain this correctly C5 = todays date Column M = Has this formula =IF(I2="","",I2-C$5) it calculates the difference in days from a random date + it also has conditional formatting. Column I = The Random date Column F = Conditional formatting if M<8 its red and if M is between 30 and 8 and its yellow(same for column M) It works fine. I would like to have a button that will add a blank row below the row I’m working in and input the formula and conditional formatting accordingly. I have tried to record a macro and searched for advise but have had no luck. I hope you can help.
Solved by A. J. in 23 mins
I have conditional formatting in a cell to catonate and am using it for a list of individuals. I only have a hand full of these individuals names (4 of 143). From the 5th name on down, which are blank, it is putting the conditional formatting, which is three different cells concatinated together (birthday like 01/01/2000). How do I get the rows that do not have names in them, which do not have the birthday to not have the // in the cells?
Solved by M. C. in 14 mins