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!”
Here are some problems that our users have asked and received explanations on
Hello I am trying to highlight a cell one of two ways based on condition. So for example Cell C3 is the previous run time, and cell C4 is the most recent run time. I want cell C4 to highlight red if the value of C3 is less than C4, but I want the cell to highlight green if the value of C3 is greater than C4... how do i two this two level conditional formatting?
Solved by I. J. in 16 mins
I have a problem regarding to How to apply Conditional Formatting with IF Statement
Solved by V. B. in 14 mins
IS there a way to highlight using excel conditional formatting entire row off of a formula instead of just a cell?
Solved by Z. H. in 29 mins
I need to use conditional formatting to highlight names that are displayed more then 2 times
Solved by M. Q. in 17 mins
I need to create an excel conditional formatting formula if that cells in column K & L if they appear more then 4 times
Solved by F. L. in 14 mins
I am trying to do excel conditional formatting blank cell that are past a certain time
Solved by T. H. in 11 mins
I am using conditional formatting =COUNTIF($D$4:$L$4,D25)
which works ok but I want it to work only if cell C4 =P. I think I need to use 'AND' but struggling.
Solved by B. W. in 28 mins
hii i have attached sheet in which "data sheet" & "Output Sheet" i have applied the formula for output sheet to fetch the data against the current dynamic condition
need to apply the conditional formatting for "output sheet"
In current data entry sheet, if the date entry haven't done for particular process, then in "current status" column it will shown as a waiting for that process
So we have to make the conditional formatting for output sheet for all vehicles numbers
if that lead time is exceeds with the standard time mentioned with reference to the job category against the total process then its should show red
Solved by O. H. in 19 mins
Please help me learn how to apply the conditional formatting in excel to highlight in red names of those billionaires who satisfy all of the following conditions:
• Citizenship of Russia or United States
• Age less than the average age of all billionaires on the list
• Net worth more than $20bil.
Solved by E. B. in 18 mins
I want a conditional formatting IF formula, here is what I have, but keep getting an error message: =If(or($A2="A", $A2="B"))
Solved by M. B. in 26 mins