Get instant live Excel expert help to learn how to combine conditional formatting with IF statement

how do i build a conditional formatting rule that highlights the cell if the cell is not empty or a reference cell contains "-P"?

I'm using the excel conditional formatting if wherein I want to highlight certain cells with the following conditions: Highlight if A4 is >=1 and B4 is >=1 and E4 is >=2 and F4 is >=3, OR if D4 is >=5 and E4 is >=2, F4 is >=3 How do I do this using the conditional formatting?

I want to create a conditional formatting on the weekly goals score, if the value is below on the Current monthly goals the score should be red and if above the score should be on green, can you help on this?

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.

I would like to highlight (using conditional formatting) all numbers in a column with decimals not equal to .0, .25, .5 or .75. So if this list includes 5.5 or 5.75, that will be ignored, but if it has 5.83, I want to be alerted. Is this possible?

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

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.

I have a list of dates in a column. I am entering conditional formatting for dates in this column - I want to highlight the date that is 2 days from now. This is easy, I enter the formula =$A1=TODAY()+2 BUT, what if I want to highlight the date that is 2 WEEKDAYS from now. How would I do that?

I have a spreadsheet that holds TWO TYPES of Table; One with Project Tasks and Gantt Chart and the second with the same Project tasks plus costs. I have FOUR formulaes/conditional formatting to complete if possible pls?

Hi, I want to put conditional formatting column wise to determine if C4 > C3, then C4 should be highlighted as Green. If C4 < C3, then C4 should turn Red. This logic should apply throughout the column. Please help