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 have a google sheet shared by the team, I set the google sheets conditional formatting, the row will turn into certain colors as cell values are updated, the next thing I want to accomplish is to move all the rows that has changed to certain colors to another spreadsheet, automatically...Is it something achievable?
Solved by X. J. in 22 mins
I have entered a data validation drop down box which when active is chosen it turns green and inactive turns red using conditional formatting. However how can I make this colour change apply to the whole row based on the choice of Inactive or Active? Please refer to F6 on the Woodside Tables tab on the attached excel document.
Solved by C. D. in 12 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 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
hello! I've searched Google for an answer but I don't think I am posing the question correctly. I have a simple excel spreadsheet (Excel 2013) that contains guest information. When the guest has left, we grey out the whole row, not just the columns that have information. The problem is when I sort the information. Currently we only have information in columns a-q, however, need the ability to use more columns as needed. When I highlight the whole spreadsheet or just certain rows and sort, usually just by agent (column b), the spreadsheet sorts correctly however with the rows that are shaded, only the columns a-q stay shaded and with any other column past q, the shading stays with the row number and not with the original content. I've looked into conditional formatting but that's formula driven which doesn't work in our case.
Solved by A. J. in 21 mins
I'm looking for a formula that I can set up for conditional formatting to highlight an entire row of cells based on the condition of two specific values. I need this rule to have 8 variant outcomes as well, differentiated by color.
Solved by I. J. in 20 mins
I need help in establishing conditional formatting in pivot table. I have two sources of data that I am able to import onto two worksheets. The first table has item numbers, width of the item, height of the item, price of the individual item. The 2nd table has the model number, width, height, and total number sold for the year. I am needing a few pivot tables. I need a price grid of individual models by width and height (width is my column, height is my row, filtered by model # - got that far) I need to add a coloring (conditional formatting) to the values by sales. I need another pivot table that can do a grid that can compare the price of the base model to the chosen model.This grid would have a percentage of the difference in price. still with the width in column and the height in the row. Beyond the basic single price grid by size....I am lost
Solved by F. J. in 25 mins
I have a pivot table for a price grid. Width in the column, height in the row, filtered by model #. Is it possible to have the pivot table have conditional formatting based off the number of doors sold? EX: 4x8 unit price is $446.00 but I want to see it yellow because only 2 were sold. Can use the formula bar in conditional formatting to say any unit price that sold between 1 and 5 is yellow?
Solved by V. U. in 14 mins
I want to highlight cells in a row based on the test in one of the calls - I think it is conditional formatting, and have tried to follow instruction, but it's not working
Solved by I. A. in 26 mins
I am looking to copy a cell that contains a conditional formatting formula into a column of other cells that would also contain the same formula but would need to perform the conditional formatting using results in its own row. My conditional formatting works fine but when I try to copy my cell to others in the same column, the conditional formatting stays on the origional cells. Is it possible to do what Im trying?
Solved by T. D. in 18 mins