# 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

Hello! How do I Apply Solid Fill Blue Data Bars conditional formatting to the % of sticker data.
Solved by E. E. in 29 mins
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?
Solved by Z. C. in 20 mins
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
Solved by B. H. in 20 mins
I need to do conditional formatting and hlookups based upon mini simulations and I am stumped
Solved by F. H. in 16 mins
I would like help with a 4 sheet excel situation with multiple sheet vlookups and conditional formatting
Solved by E. S. in 15 mins
I am struggling to create an excel conditional formatting formula based on another cell. which changes color depending on the proximity of the contents of the second cell
Solved by I. Y. in 21 mins
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?
Solved by B. H. in 20 mins
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
Solved by I. J. in 29 mins
I am using duplicate control in excel through Conditional Formatting, total 18,500 nos. of Rows are existing in the sheet. Filter with Highlight Color is not working now. Please suggest me the best way to check duplicacy..
Solved by O. Y. in 20 mins
Hi there need some help with conditional formatting please, using =AND(LEFT(K\$4,4)="1350",K9>K34,K5<>"Buy") trying to make the cell not highlight red if buy is in row 5 but not working
Solved by O. B. in 20 mins