# 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

I am trying to form a list of duplicates in a large spreadsheet. I have already done conditional formatting to highlight duplicates in two columns but cannot extract the duplicates to a separate list.
Solved by Z. H. in 30 mins
i need help regarding conditional formatting. i want to create an excel conditional formatting based on another cell value. example is given on attached sheet
Solved by A. A. in 23 mins
Hi im trying to use conditional formatting on a line if it meets 2 criterias. here is what ive tried but it isn't working:- =AND(\$G14<TODAY, \$E14="Not Started", \$E14="In Progress", \$E14="Delayed", \$E14="n/a")
Solved by O. Q. in 21 mins
I need help on conditional formatting dates. So in short, I need the cells to be red if the date is between the 1st and 14th, then green if the date is between the 15th and 30th (or 31st). The current formula I am using is the following: RED =TODAY()>DATE(2017,8,1) =TODAY()>DATE(2017,9,1) =TODAY()>DATE(2017,10,1) =TODAY()>DATE(2017,11,1) =TODAY()>DATE(2017,12,1) GREEN =TODAY()>DATE(2017,8,15) =TODAY()>DATE(2017,9,15) =TODAY()>DATE(2017,10,15) =TODAY()>DATE(2017,11,15) =TODAY()>DATE(2017,12,15) So, I went in to the "Conditional Formatting" then went to manage rules, add rule. Then I did it in order of month, red to green. For example I would copy and paste the 8/17 red code and then the 08/17 green code, in order up to December 2017. It is now the 20th and I opened the excel sheet to check if the cell would be green because the date range but it is not. I have an attachable image.
Solved by E. F. in 19 mins
Hello, I am looking to highlight the cells that have text in them to highlight as red between the 1st through the 15th of every month, and then be green the 16th through last day of the month whether it be the 30th, 31st, or even 28th (depends on the month). I attached a sheet in which I was testing by highlighting all of the cells with text (the 1 of 8, 2 of 4, etc.) then clicking "Conditional Formatting" > "Highlight Cells Rules" > and then either Greater Than or Less Than for both red and green using the following formulas for each month: Less Than (Red): 2017-08-15 2017-09-15 2017-10-15 2017-11-15 2017-12-15 Greater Than (Green): 2017-08-15 2017-09-15 2017-10-15 2017-11-15 2017-12-15 I am not sure what I am doing wrong but when I did the formula and chose the colors for August, it seemed to work fine, being today's date would be within the right date range for the cells to highlight as green. I then removed the August formulas and replaced them with September formulas, it did not seem to work.
Solved by C. W. in 14 mins
I want to highlight cells in a row based on the test in one of the calls - I think it is conditional formatting, and have tried to follow instruction, but it's not working
Solved by I. A. in 26 mins
Hi I am looking for help on conditional formatting I have two ranges of 11 cells and I would like a singular cell in the first range to flash red if it less than the bottom range, could you please assist?
Solved by D. L. in 17 mins
Yes hello Im looking for help on excel conditional formatting if statement. I currently have a conditional format for D9>D32 and so on from D9:S20. I need to add an if statement that references cell D4 if the first four characters are 1358 for the rule to apply can you please assist?
Solved by Z. U. in 11 mins
I am looking to copy a cell that contains a conditional formatting formula into a column of other cells that would also contain the same formula but would need to perform the conditional formatting using results in its own row. My conditional formatting works fine but when I try to copy my cell to others in the same column, the conditional formatting stays on the origional cells. Is it possible to do what Im trying?
Solved by T. D. in 18 mins
Hi there, need help on conditional formatting in excel 2010. Im trying to apply conditional formatting to cells that do not contain a formula. I've used a macro to create the =ISFORMULA function but the conditional formatting is not working if the formula returns FALSE
Solved by O. F. in 29 mins