# 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 to know how I can make this Google Sheet file an excel file while preserving all of its conditional formatting functions.
Solved by S. C. in 22 mins
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?
Solved by B. F. in 28 mins
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.
Solved by B. H. in 25 mins
i need to do a conditional formatting rule for greater than.
Solved by I. B. in 23 mins
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.
Solved by E. E. in 29 mins
I am trying to use conditional formatting to color the space between two data entries. Here is an example of what I am trying to do, I colored the cells just as an example. This would be a shared spreadsheet where rental home owners would have access to the sheet and would enter in the check in and check out dates for the guest, usually multiple time a month. Any suggestions or ideas ? Thanks
Solved by B. B. in 19 mins
I have 2 columns with dates in and want to have a column that shows the most recent date so that I can then use conditional formatting to change the colour of the box depending on the age of the date eg in last 6 months. How do I get Excel to look at the 2 columns and provide me with the recent date ?
Solved by C. E. in 22 mins
I need help with Conditional Formatting with three conditions. I can get two of the conditions to work but not the third. Can you help me?
Solved by M. L. in 17 mins
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?
Solved by K. B. in 13 mins
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.
Solved by C. U. in 24 mins