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!”
Here are some problems that our users have asked and received explanations on
I hope I explain this correctly
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)
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 X. Y. in 21 mins
hi, i want to change the background of cells in the same column with dates in and I am having trouble with conditional formatting for blank cells.
I want cells equal to or less than to turn red, so expired dates.
i want cells 1-3 days in the future to turn yellow.
i want blank cells to remain uncoloured.
I have tried conditional formatting with these codes.
=NOW()
=NOW()+1 and =NOW()+3
Blanks, no colour
I find that it doesn't change automatically, and that all the blank cells either go red or yellow.
its really frustrating me now, can anyone help please :)
Solved by F. Y. in 11 mins
I need assistance with the following items
1.Using the Conditional Formatting, determine which students have provided over $50 for the fundraiser in Funds Received Column and also in Funds Pending Column.
2.Click on any cell in (A1:E22), and apply a design to your data: In the Styles group, select Format as Table and use a dark formatting option.
3.At Total row (E22 and F22), provide a Sum for the Funds Raised and Funds Pending.
4.Add the Title "College Fundraiser Project" by inserting blank lines. Change the font size of the title to 22, fill color with white background, darker 35%.
Solved by Z. Y. in 27 mins
I have a formula in a cell & I have done conditional formatting to that cell. There is no data in the particular cell, as per the conditional formatting I have set if there is no data in a cell it should show blank but it is showing as "0" with a different color.
Solved by V. Q. in 21 mins