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!”
Here are some problems that our users have asked and received explanations on
Conditional Formatting problem with formulas. I'd like someone with lots of experience. The best rep you have if you would please.
Solved by Z. L. in 30 mins
Hi wondering if I can use conditional formatting to have set text in one cell create a strikethrough text in another cell
Solved by V. U. in 27 mins
I would like to create a conditional formatting for my template, For absenteeism I want to make it red if above 5% and if below make it green for utilization I want to make it red if below 85% and green if 85%.
Solved by B. B. in 27 mins
I'm looking to highlight a cell if its date is more than 60 days past another date in another cell.
For example, let's say the date in C2 is 10/16/2018 and the date in B2 is 10/16/2017. I would like C2 highlighted because it is more than 60 days in the future from the date in B2.
Is there a conditional formatting formula for this?
Solved by D. J. in 23 mins
I'm trying to create a shading formula to find prerequisites. If E2 contains "IT-420", and cell F2 contains at least "IT-489", then E2 should be shaded yellow
I try this formula in cell, and it works, but when I go to use a conditional formatting formula, it doesnt.
="IF(AND((E2>=""IT-420""),(F2>=""IT-489"")))"
Solved by Z. F. in 25 mins
trying to compare if amounts in one column E are greater than amounts in column G, using this formula =E1>G1 with conditional formatting, and not working.
Solved by G. S. in 30 mins
I need help with conditional formatting in ms excel. I want to highlight and hide rows based on the value I.
If I = 19 or higher, highlight row black with white text and hide the row
Solved by I. A. in 18 mins
Hi im trying to do conditional formatting on 2 lists of titles to see if they both contain the same words but cant find a good working formula to do so
Solved by V. S. in 18 mins
I need a conditional formatting formula that highlights a selected row when a cell has any data in it. I have tried LEN($AF3)>" " What I need to track is when a value of $0.00 or greater is entered, it colors a row. If I use just plain zero, even if the cell is empty, it colors the row. I don't want it to color fill unless there is data in the one cell
Solved by T. S. in 14 mins
I need to create conditional formatting that colors the row green if there is data in column E and red if column E is empty.
It also has to be variable, since it will be varying in size
Solved by T. H. in 12 mins