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

Stuck on some conditional formatting. I need column C to turn red only if column B is <50 or >90 AND column C is <.2 I'm not all that good with if, and, then statements.
Solved by D. H. in 13 mins
I have entered a data validation drop down box which when active is chosen it turns green and inactive turns red using conditional formatting. However how can I make this colour change apply to the whole row based on the choice of Inactive or Active? Please refer to F6 on the Woodside Tables tab on the attached excel document.
Solved by C. D. in 12 mins
I have two columns of dates, and I need to apply a conditional formatting rule so that; If a date in Column B falls within 0-3 months of the date in Column A (same row), it highlights Green If a date in Column B falls within 3-6 months of the date in Column A (same row), it highlights Yellow If a date in Column B falls within 6-12 months of the date in Column A (same row), it highlights Red
Solved by X. S. in 25 mins
I would like to be able to lock a time stamp in one column after i enter data in an adjacent column. In the attached spreadsheet, I would like to have data entered in "completed by" and "supervisor review" columns and have the adjacent columns show and lock the time stamp. Also, if you notice that there are certain tows that are highlighted. Those are high priority items that are critical items. I already have the spreadsheet conditionally formatted so once the task is review by the supervisor, the highlight disappears. I would like for that conditional formatting to stick as I will need to adjust the items. Thanks
Solved by I. J. in 28 mins
We are creating a new customer classification system to focus on our largest customers. Our biggest customers are going to be called “Gold” class customers and the next group will be called “Silver” class customers: “Gold” class customers are those whose average monthly sales for the last twelve months are $7,000 and greater or the average previous quarter sales are $7,000 and greater. “Silver” class customers are those whose average monthly sales for the last twelve months are between $2,000 and $7,000 or the average previous quarter sales are between $2,000 and $7,000. Add a column next to the average monthly sales on the AR Aging sheet called “class” and make the word “Gold”, “Silver”, or blank appear as explained above. HINT: Do not try to do this step with Conditional Formatting. Now format these three columns: (1) Customer #, (2) the Customer Name, and (3) Class. Format all of these columns with gold fill and white font for the "Gold" class customers, and silver fill and white font for the “Silver” class customers. On the aging report, add our company’s logo (your choice of an appropriate logo), put a useful title on the report, add a freeze pane, and follow all Standards of Professionalism (only for the AR Aging report). The Standards of Professionalism are described in this list . You can also review this video tutorial to watch an explanation of the Standards of Professionalism.
Solved by B. D. in 12 mins
I'm trying to find the conditional formatting, I am using excel online.
Solved by A. S. in 14 mins
Date highlight conditional formatting not recognizing cells with EDATE formula adding more than 5 months to date. For example: Conditional Formatting: Current month = Highlight Green Start date in cell A1: 3/1, next cell has formula =EDATE(A1,3) Formula populates new date to 6/1 and CELL TURNS GREEN Start date in cell A1: 12/1, next cell has formula =EDATE(A1,6) Formula populates new date to 6/1 and CELL DOES NOT TURN GREEN Start date in cell A1: 9/1, next cell has formula =EDATE(A1,9) Formula populates new date to 6/1 and CELL DOES NOT TURN GREEN
Solved by A. E. in 19 mins
I have a spreadsheet that I have to print daily schedules from I have it conditional formatted so when I enter an X in the first cell of the row the row highlights. Through out that row there are X's in the cells of the daily sheet I must print from tabs at the bottom of the spreadsheet. So I have two questions: Is there a formula that I can write so when I enter that X in the first cell it makes any other cell with an X in it print the corresponding bottom tabs daily schedule sheet. So looking at this I want the first X to say print sheet 3,8,12,15 from the tabs below. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 x x x x x tabs at bottom 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Or this would be my other option: Conditional formatting. My other question is on this same spreadsheet, Is there a formula that I can write so that when I enter that same X in that first cell I have conditional formatting that will highlight the X's in that row a color of my choice. I am thinking some kind of IF / THEN statement.
Solved by A. A. in 17 mins
Sheets is a great example for chaos theory. Every time I sort, the formatting disappears on half my data. Eventually the sorting will delete all my sorting and leave a great deal of useless commands in "conditional formatting"
Solved by G. J. in 23 mins
I have a spreadsheet with student names and their grades for each subject. I'm supposed to use conditional formatting to put each student who failed a grade's name in red
Solved by I. D. in 25 mins