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

How do I create a formula for conditional formatting that will highlight the entire row if the value in A is a number and the value in B is an error.

i would like to apply conditional formatting in excel to my cells. i would like cells O2-O27 to highlight if they are greater than cells N2-N27. How can I do this?

I have a worksheet with 19 rows of data across 13 monthly columns (E10:Q28). This data range contain the past 13 rolling months of data against 19 stock prices. Each month I calculate in column T10:T28 the difference between the latest price of each stock, and the earliest/oldest. Some stocks were purchased within the 13 month period, so the earlier month's cells will be empty of data. Each month I take the past 12 months columns of data (F10:Q28) and overwrite (paste) them into the first 12 months (E10:P28), and then overtype Q10:Q28 with the latest month's data. This is to protect conditional formatting across all cells in the range. I would like to have a formula in T10:T28 that works out the latest price minus the earliest price, taking empty cells into account. I can modify the individual calculations in T10:T28 where there are less than 13 months of data, but I would like to automate it if I can.

I would like to use conditional formatting to be able to make the colour of row change according to the date in that row in one of the columns. So that the rows are one colour if the date is up two one week old then another colour for 1 to 2 weeks old, then another colour for over 2 weeks old.

I've used conditional formatting to highlight the lowest and highest numbers in a row. The problem is I want to use the same format to highlight the highest and lowest numbers in the next 1000 rows in exactly the same way. Each time I try to use format painter it doesn't work and if I try and highlight all the cells then it will only highlight the highest and lowest number from all the highlighted cells regardless of what row they are in. To make matters more complicated the columns I want excel to take the information from aren't adjacent to one another. Can you help please?

Hello i have this formula in a cell, =IF(I11<>"",IF(H11="",NOW(),H11),"") and i want to conditional format this cell to turn green if its within a a range of time say for instance between the hours of 6:00 am - 8:00 am, and to turn red if it is outside that time frame and no color if it is blank.. I have tried multiple things and i cannot get the excel to recognize the cell as a time instead of a formula, i could not find a time option in conditional formatting.

Hi I am just looking for help with my conditional formatting formula =AND(LEFT(F$4,4)="1350",F9>F34). I want to add a condition to it that if Cell F5=buy, then the formatting does not apply. Can you please assist?

Hi just looking for some conditional formatting excel 2010 help. I am looking for a way to highlight red a range of cells if they do not contain a formula

Good morning. I'm just trying to work out if it is possible with Conditional Formatting to make it so that a cell would be filled in with a colour when the number value becomes 8500 more than the value of another cell. I've been able to do it if the cells are in a row using the =SUM function but if the two cells are in different locations on the spreadsheet (e.g A2 and E16) it doesn't want to do it. Is there a way I can do this?

The spreadsheet is being used to track attendees to courses. So when they confirm a date it goes in Collum G I would like to get conditional formatting to do the following: White if greater than 15 days Orange if between 3 – 14 days Green if today – 2 days My current conditional formatting for those cells are: White:Cell Value > =NOW()+15 Orange: Cell Value between =NOW()+3 & =NOW()+14 - Green: Cell Value between =NOW() & =NOW()+2