Get instant live Excel expert help with conditional formatting

“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

neeeeed helppp in a sheet I want to use conditional formatting with multiple criteria it is a difficult taks please answer if you can do that asap please
Solved by C. B. in 11 mins
I am having an issue trying to figure out some conditional formatting for a spreadsheet. It is more than just one function. It's either an ifs string or and/if string I think. But you are the experts. Help.
Solved by E. Q. in 26 mins
I need help with a formula of color changing (conditional formatting), can you show me excel formula based on cell color
Solved by Z. W. in 15 mins
I just want to be able to use conditional formatting, and it brings up the rest of information?
Solved by S. H. in 20 mins
I am attempting to add conditional fomatting to column C, however, the cells with the VLOOKUP formula in them will not reflect the formation. C3-C6 do not have formulas and show the conditional formatting can you assist? The formatting should process from red to green from 20 to 70 being the all green,
Solved by D. D. in 18 mins
I’m working on a project in which I need to have the rows (A to I) to be highlighted in specific color based on the text provided in the particular cell, if it is a single row/cell I’m able to do it thru conditional formatting but it is required it in multiple rows. For Eg. If Cell A1 has the text “Naren” and cell A2 has “B” then the row should be highlighted in Green and the same cells has the text of “Bas” and “C” then the row should be highlighted in red, point to note here is the text will be in multiple rows and in whatever rows/col (cell) it is updated the particular row should be highlighted with specified color.
Solved by S. J. in 29 mins
How to write a conditional formatting excel formula which will apply formatting to C2 IF: C2 contains a value which appears more than once in column C AND ( G2 does NOT contain the text "0001-01-01" OR F2 value is greater than 7/24/17)
Solved by S. Q. in 28 mins
I have created a Gantt chart. I have a category column I have added conditional formatting to, to control the color based on my key. I want the horizontal duration bars in my chart to match the color formatting of the category associated with each task duration, but I can't figure out how to do it. I'm thinking it'll be based on a conditional formatting in excel formula but i'm not finding what I need online.
Solved by M. Q. in 26 mins
i need a formula that calculates a number and then conditional formatting that assigns a color
Solved by B. C. in 22 mins
I want to conditional format an entire worksheet, where if the value in a cell is greater than the value in B of that row, the cell is highlighted. However, per line, the value in B is VARIABLE. Example: if in B2, the value is 100, any values in row 2 higher than this will be highlighted. If in B3, the value is 200, any values in row 3 higher than 200 will be highlighted. Values less than 200 but over 100 should not be highlighted in row 3, as they should NOT be affected by the formatting copied down from row 2. Conditional formatting needs to understand the X variable for Greater Than in column B is changing PER ROW. I can make this work by clicking each row and applying formatting manually, however there are several thousand lines of data to format, and I need this to go quicker.
Solved by B. F. in 27 mins