Get instant live Excel expert help to learn how to apply conditional formatting to a row

“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

How do I use conditional formatting to colour a cell when the date in one column matches the date in a row along the top of the chart? The coloured cell should be the cell that corresponds between the column and cell.
Solved by B. B. in 27 mins
I need a formula to use in Conditional Formatting that will highlight the first cell in a row containing any value >0 and another formula that will highlight the last cell in a row containing any value >0. For example, my first row is C2:S2, where the first cell>0 is F2. I need a formula that will start looking in D2 and look until it reaches F2, where it will highlight that cell then move to row C3:S3. I am using Excel for Mac 2016.
Solved by V. U. in 30 mins
Conditional formatting, i need to highlight a row 1 week on due date
Solved by D. J. in 24 mins
I am trying to use a simple Conditional formatting to highlight the row based on the data in column B. My formula is copied from several other online sources. I am actually using the same formula in another workbook, and its fine. I don't understand why this isn't working. =\$B2="NA" is the formula. Chose a color for highlighting. Selection of my entire sheet - Nothing. It doesn't highlight. I have moved the formula and changed the data. Lost and Confused. please help.
Solved by D. B. in 14 mins
I'm trying to set-up conditional formatting for the following. I want it to change the row to yellow if there is a date in D1 A1 B1 C1 D1 red blue white 7/24/2018
Solved by E. E. in 27 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 AM TRYING TO GET A SELECTED FEW CELLS WHICH INCLUDE WORDS TO HIGHLIGHT A CORRESPONDING WORD IN THE SAME ROW USING CONDITIONAL FORMATTING
Solved by B. S. in 28 mins
Hi, I am have an excel budget sheet with three important rows at the bottom. 1. a sum of each column. 2. a row with the copied value of the sum-value above to hava as a control. 3. a formula that subtract the above values (I would like this value to be zero as a control). To the first and third row I would like to have conditional formatting, coloring them red if they are not the right value (i.e: the 1st row to colour red if its not the same as thr 2nd row, and the 3rd row to colour red if its not zero). This contitional formatting only applied correct to three of my columns, and three colours red even if the values are correct.
Solved by S. F. in 26 mins
When a cell is clicked, the entire row of that cell should be highlighted temporarily. I need this conditional formatting entire row so that it is easy to navigate through the row of a selected cell.
Solved by T. D. in 21 mins
NEED HELP WITH THE EXCEL CONDITIONAL FORMATTING BLANK CELL. IM ADDED A NEW ROW EACH WEEK AND WANT MY FORMATTING BUT DONT WANT MY WHOLE PAGE TO BE COLOURED WHEN THE CELLS ARE BLANK
Solved by X. W. in 16 mins