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

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