Get instant live Excel expert help to learn how to apply conditional formatting to a row

“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

Hi I was trying to see if it was possible to transpose data in between conditional formatting. Basically if there is data in between a coditional formatting cell it would transpose the data (from a column to a row) and once it hits the next conditional formatting cells in excel it would move to the next row. Example A1(Conditional Formatting Cell) A2 A3 A4 A5(Conditional Frormatting Cell) to: A1 A2 A3 A4 A5 etc etc
Solved by G. J. in 16 mins
How do I create a formula for conditional formatting that will highlight the entire row if the value in A is a number and the value in B is an error.
Solved by G. U. in 22 mins
I would like to use conditional formatting to be able to make the colour of row change according to the date in that row in one of the columns. So that the rows are one colour if the date is up two one week old then another colour for 1 to 2 weeks old, then another colour for over 2 weeks old.
Solved by E. E. in 29 mins
I've used conditional formatting to highlight the lowest and highest numbers in a row. The problem is I want to use the same format to highlight the highest and lowest numbers in the next 1000 rows in exactly the same way. Each time I try to use format painter it doesn't work and if I try and highlight all the cells then it will only highlight the highest and lowest number from all the highlighted cells regardless of what row they are in. To make matters more complicated the columns I want excel to take the information from aren't adjacent to one another. Can you help please?
Solved by K. B. in 13 mins
Good morning. I'm just trying to work out if it is possible with Conditional Formatting to make it so that a cell would be filled in with a colour when the number value becomes 8500 more than the value of another cell. I've been able to do it if the cells are in a row using the =SUM function but if the two cells are in different locations on the spreadsheet (e.g A2 and E16) it doesn't want to do it. Is there a way I can do this?
Solved by B. H. in 20 mins
Hi there need some help with conditional formatting please, using =AND(LEFT(K$4,4)="1350",K9>K34,K5<>"Buy") trying to make the cell not highlight red if buy is in row 5 but not working
Solved by O. B. in 20 mins
Could someone help with a conditional formatting formula please. I have a worksheet where i would like a row to be highlighted depending on a couple of conditions. The sheet is K to Y in M is the leave date of the staff member then in Q there is a drop down list containing 3 options Deleted, Proxy for 1 month and Proxy for 3 months If the option Proxy for 1 month is selected then i would like the row highlighted when the date in M is one month old If the option Proxy for 3 months is selected the i would like the row highlighted when the date in M is three months old. If deleted is selected then do nothing. Just cannot get the date thing!
Solved by K. J. in 24 mins
Hi there looking some help on conditional formatting. the formula I am using is =AND(LEFT(K$4,4)="1350",K9>K34,K5="sell") and it applies to =$K$9:$Z$22. But for some reason it is only working for the row 9 and no others. Could you please assist? I unfortunately cant share the file because it has company information
Solved by A. W. in 18 mins
Making a dynamic gantt chart using conditional formatting, IF statements, WEEKDAY function, drop down menus, etc. 1. COMBINE THESE FORMULA INTO A SINGLE NESTED IF STATEMENT. SO FAR I HAVE RUN INTO CIRCULAR CELL REFERENCE ISSUES SO I AM NOT SURE IT THIS IS POSSIBLE OR IF WE NEED TO FIND ANOTHER WAY. If (Start Date=Row Date, when true, fill in a value of 1, if false, no value. IF(E10=K9:DI9, 1,””) Search the row and insert a 1 on the correct starting date. This formula is correct. If(sum of K10:DI10<D10,1,””) Insert a 1 value until the total number of days is reached. This formula allows us to add in travel days for clients quickly by replacing a 1 value with an x. The formula automatically inserts a 1 value at the end of the plan for each “x” input. Does not count values of “” or x. This formula is correct. If Delivery Date=5, insert an “x” for WEEKDAY value of 7 and 1 (Do not make food on Friday and Saturday) If Delivery Date=6, insert an “x” for WEEKDAY value of 7 (Do not make food on Friday) If Delivery Date=7, no action required (Deliver meals 7 days per week) This formula needs to be written. Conditional formatting for table: 1 value = green font, green background, complete x value = grey font, grey background, This conditional formatting is set. 2. DYNAMIC END DATE Use a formula to look up the last value of 1 in the row K10:DI10 and return the date from K9:DI9. This value will be shown in cell F10 In cell F10, =find the final 1 value in row K10:DI10 and return value from K9:DI9. This allows us to automatically update the end of plan to inform clients when their renewal is due. This formula needs to be written. 3. SET THE PROJECT START AND END DATE IN CELLS C5 AND C6 TO AUTO FILL THE CALENDAR DATES.
Solved by S. Q. in 23 mins
I am truly a beginner in Excel and need all the help I can get! Okay so I have a table that is $A$2:$N$333 and I would like column A to show a data bar to reflect the data that each row has completed. Example: Row 3 has data in every column up to G now I'd like Cell A3 to show a 50% data bar in that cell to show that only 50% of the data needed for that row has been entered. Is that possible and how would I go about doing so? (this is the reply I revieved from tech support) If you add another column for the data bar, you can do it with conditional formatting. If you insert a column before column A and inserted this formula: =COUNTA(B5:O5)/14 And then use conditional formatting in the cells in column A (open) conditional formatting Use: format all cells based on their values Choose data bar from drop down check box to show data bar only (in type) choose number from drop down Enter 0 on minimum and 1 on max Use solid fill and no border and hit okay I COULDN'T COPY AND PASTE THE IMAGE SO I DESCRIBED IT AS BEST AS POSSIBLE (This is my reply ) So after I've entered the formula into each cell down column A do I high light all of column A and then select the conditional formatting with Data bar? So I did Just that I copied the formula into each cell in column a and then I highlighted the column and did the conditional formatting using Data bars and I got nothing. In the picture it says edit formatting rule. I made a new rule with all of column A highlighted was I supposed to go through the manage rules window instead of make a new and also in the picture it says minimum (Type) Number 0 and max Number 1 was I supposed to put that in as well? Thanks for all your help I'm sorry I am so new at this excel stuff AND THEN I RECEIVED THIS REPLY Yes, you need to have it look exactly like the image I posted for it to work, so you'll need the types to be numbers and values to be 0 and 1. OKAY SO THIS ONLY ANSWERED ONE OF MY QUESTIONS AND IT STILL ISN'T WORKING CAN YOU HELP ME? PLEASE THANKS FOR ALL YOUR HELP VINTA
Solved by E. Q. in 26 mins