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

“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 am trying to work how I can create a conditional formatting on a selected cell when a previous cell has been selected as a certain icon in a list. For Example: When I select my category 'RTW' from the choices in my list in column B, I want it to pick up on column C if I have not entered the right amount of figures in the cell (it needs to be exactly 12 digits). If it is incorrect I need it to highlight red.
Solved by M. H. in 27 mins
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 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
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
i am trying to do a conditional formatting where if one column doesn't follow the < or > in another column to the value in the third column it will highlight it
Solved by D. D. in 26 mins
I have conditional formatting to highlight a cell if another cell is filled( =C7:C30<>"" ) but once that highlighted cell is filled I want it to unhighlight. Nothing I have done has worked.
Solved by M. H. in 16 mins
I have a table of data showing how much each individual produced every day of the year. I then summed the total for each individual for the entire year. I would like to narrow down which individuals had a total below average, shown on a different table. I am only able to countif individuals were below average, but I want to show specifically which ones were below average, instead of going manually and picking which ones were below and which ones weren't (it is a lot of data). I have already used conditional formatting to help me visualize which ones were above average (shown in green cells) and which ones were below average (red), but I would still have to pick them individually if I were to represent in a new table specifically which ones were below average. Any help on which equation can perform this action? It would be something like show which individuals were below average, and the result would be about 50 data points in 50 different cells.
Solved by S. H. in 25 mins
Hi! I want to code my excel so that it will copy the data from multiple cells to another location using conditional formatting. For example, if the word in cell D4 is not equal to the word in cell E4, I want it to copy cells B4, C4, D4, and E4 to another location on the document. Furthermore, I would like to have this run through multiple rows without leaving spaces in the "copied" area. I could code it as an if statement (which would take forever because i have a lot of data) but I don't think it would allow me to have as many in-bedded if statements as I need. Thank you for your help!
Solved by K. L. in 20 mins
I want to apply conditional formatting to column E in the "MASTER" sheet. This will be with values of Hi, Medium, Low or Standing Item. If "Hi" is written the cell will glow red, if "medium" is typed into a cell in that column E the cell will glow orange and if a value of"low" is written the cell will glow green and if a value of "Standing Item" is written the cell will glow blue... but right now when I try to do this and then hit the "Update" button to have the macro run... all of the conditional formatting works on the main "MASTER" sheet but none of the conditional formatting works on the other sheets even though all of the actual data(words) are transferring to each sheet from the "MASTER" sheet the right way.
Solved by Z. H. in 11 mins