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 need help with conditional formatting. shouldn't be too hard
Solved by V. B. in 25 mins
I need some help with conditional formatting of cells that contain certain special characters
Solved by B. W. in 13 mins
Conditional Formatting Question: I want to highlight the top cell (title cell) of a column based on the information in that column. I.e. if there are empty cells in column C, the title of the column (C2) is highlighted red.
Solved by T. F. in 19 mins
I'm trying to have a cell turn red if it took more than 5 minutes to complete task. Column D is the result of subtracting B(time in) from C(time out). Ideally, there would be conditional formatting in column C that would turn red when over 5 minutes. However, I can't get it to work.
Solved by V. U. in 26 mins
I would like cells in Column A to highlight based on whether or not a cell in column G is highlighted. (Column G has conditional formatting applied based on a specific date)
Solved by F. Y. in 23 mins
Conditional Formatting: Using cells from another sheet. I want the conditional formatting from Sheet 2 to be mirrored on the same named cell in Sheet 1. I used this formula: =match($A:$A, indirect("HLP!C1:C"),0) But when the Sheet 2 cell being referenced too is no longer highlighted, it's still highlighted in Sheet 1
Solved by Z. H. in 18 mins
Hello, I want to change the font color for lines that have been updated. If a new position or new step is entered, the font colour of the entire row should be changed in orange. Column E > conditional formatting > manage rules > New rule > Use a formula to determine which cells to format Formula =IF(NOT(ISBLANK($E2)),TRUE) Format = Bold orange color Applies to : =$A$2:$F$2 How to replicate it to the following rows? The formula does replicate but not the Applies to For row 3 I should get Formula =IF(NOT(ISBLANK($E3)),TRUE) Format = Bold orange color Applies to : =$A$3:$F$3 Thank you
Solved by I. A. in 12 mins
I have data in two columns A and B. I have 9 conditions based on those two columns.Like if A<0, B<0 I want it in green colour, if A<0, B>0 in another colour, if A<0, B=0 in another colour, if A>0, B<0 in another colour, if A>0, B>0 in another colour, if A>0, B=0 in another colour, if A=0, B<0 in another colour, if A=0, B>0 in another colour, if A=0, B=0 in another colour,. How can i achieve it by conditional formatting
Solved by K. A. in 18 mins
Hello, can I add a drop down menu to a cell with conditional formatting. So that when the cell turns green I can use the drop down menu, but when it is red, the drop down menu is not there.
Solved by K. J. in 27 mins
i WANT TO DO CONDITIONAL FORMATTING WITH AND IF/OR STATEMENT
Solved by D. W. in 18 mins