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
How do I setup excel conditional formatting based on text in another cell?
Solved by E. Y. in 16 mins
conditional formatting lets say the pass date was 01/09/18 this format should be highlighed green, if it is now at 18 months from this date (01/03/20) it should highlight Orange, and if it is at 30 months from the pass date it should highlight Red.
Please Help
Thank you
Solved by V. H. in 17 mins
Need to apply the conditional formatting: D4:R14
COLOR OF CELL HAS TO CHANGE IF THE LEAD TIME OF THE VEHICLE NUMBER AGAINST THE STATUS
e.g RJ14UE1227 HAS STATUS AS A "AWAITING VEH ESTIMATION" HAS CROSSES THE STANDARD LEAD TIME THEN ITS SHOULD Tern red.
Standard lead time is define in" Data sheet: I4:AC8"
first we have to check the JOB Category in column "D" AND THEN current condition with reference to column "G'
for that current condition formula has to calculate the standard lead time
then actual lead time has to calculate by considering today date & received data from Colum no "J"
Solved by D. H. in 21 mins
Need help applying conditional formatting to entire row, highlight the entire rows for top five highest positive and top five highest
negative % change values . You will need to use LARGE and SMALL functions .
Solved by X. U. in 12 mins
I need help with microsoft excel conditional formatting. Highlighting a cell once the sum of other values reaches a certain point
Solved by K. W. in 11 mins
How can I add conditional formatting text on a list and that will highlight the row if the first cell is filled?
Solved by K. U. in 30 mins
I need conditional formatting based off a range of cells. Getting error: This type of reference cannot be used in a Conditional Formatting formula.
Solved by O. W. in 21 mins
conditional formatting to highlight rows where an actual duration lasts 25% longer than the scheduled duration
Solved by E. Y. in 29 mins
I have a problem regarding to How to Use Conditional Formatting to Change Cell Background Color Based on Cell Value
Solved by E. Y. in 28 mins
I have a problem regarding to How to Apply Conditional Formatting If cell is Blank
Solved by C. J. in 16 mins