# 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

Hello I would like to highlight entire row of a table if one cell in row equals yesterday. I do not know how to do it with conditional formatting.
Solved by F. H. in 24 mins
Hi there. I'd rather not share my spreadsheet, but I'm hoping that you'll be able to assist me still. I'm working with conditional formatting and have my sheet set to format on text (Vacant Ready, Occupied, and Notice). The only problem is that it's only highlighting the specific cells that say that, when I am needing the entire row to match based on the status. Does that make sense?
Solved by K. H. in 25 mins
Add Minimum Cost and Maximum Cost rows that are formatted similarly to row 50 (Average Cost row). Use functions to calculate the minimum and maximum costs for the systems purchased. Convert the Initial Cost data including the Average Cost, Minimum Cost, and Maximum Cost, and the Depreciated Value data from a generic number to accounting format with no decimal places. Copy the average, minimum, and maximum functions to the Depreciated Value columns. Merge and center the title “Desktop & Laptop Systems Inventory & Depreciation” above all of the columns with data. The CEO has asked you use conditional formatting to create an easy visual on the spreadsheet of any device that is near the end of its useful life. Utilize conditional formatting for all columns that contain a depreciated value of less than \$500 they will appear red. Create a pie chart to show the initial cost totals by department. You may create a set of summary data to the right of the current data to use for the creation of your chart.
Solved by Z. A. in 24 mins
I’m working on a project in which I need to have the rows (A to I) to be highlighted in specific color based on the text provided in the particular cell, if it is a single row/cell I’m able to do it thru conditional formatting but it is required it in multiple rows. For Eg. If Cell A1 has the text “Naren” and cell A2 has “B” then the row should be highlighted in Green and the same cells has the text of “Bas” and “C” then the row should be highlighted in red, point to note here is the text will be in multiple rows and in whatever rows/col (cell) it is updated the particular row should be highlighted with specified color.
Solved by S. J. in 29 mins
I want to conditional format an entire worksheet, where if the value in a cell is greater than the value in B of that row, the cell is highlighted. However, per line, the value in B is VARIABLE. Example: if in B2, the value is 100, any values in row 2 higher than this will be highlighted. If in B3, the value is 200, any values in row 3 higher than 200 will be highlighted. Values less than 200 but over 100 should not be highlighted in row 3, as they should NOT be affected by the formatting copied down from row 2. Conditional formatting needs to understand the X variable for Greater Than in column B is changing PER ROW. I can make this work by clicking each row and applying formatting manually, however there are several thousand lines of data to format, and I need this to go quicker.
Solved by B. F. in 27 mins
I have a bill of material sheet with parts in different levels like 1 2 3 4 5 6 6 is inside 5 5 is inside 4 3 and 2 are inside 1 Need to know some way to strike off all below one if 1 is striked off by conditional formatting this will go on till it sees next 1 in different row same column
Solved by T. W. in 16 mins
I am trying to have the current date populated once text is entered into that row. I came up with the following excel conditional formatting formula but nothing seems to happen...no error...no data. =IF(B2=""' IF(D2="",NOW()D2),"")
Solved by X. D. in 20 mins
Freeze the first row on the Fleet Information worksheet. Convert the data to a table, name the table Inventory, and apply the Table Style Medium 19. Remove duplicate records. Sort the table by Make in alphabetical order, add a second level to sort by Year Smallest to Largest, and a third level to sort by Sticker Price Smallest to Largest. Repeat the field names on all pages. Change page breaks so each vehicle make is printed on a separate page. Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. Click the Sales Information worksheet and convert the data to a table, name the table Sales, and apply the Table Style Dark 11. Type % of sticker in cell E1. Create a formula with structured references to calculate the percentage of the Sticker Price in column E. Format the range E2:E30 with Percent Style Number Format. Add a total row to display the Average of % of sticker and Sum of Sticker Price and Sale Price. AutoFit the width of columns B:E to show the total values. Apply Solid Fill Blue Data Bars conditional formatting to the % of sticker data. Select the range E2:E30 and create a new conditional formatting rule that uses a formula to apply yellow fill and bold font to values that sold for less than or equal to 70% of the sale price. On the First Quarter Sales worksheet, rename the table FirstQuarter. Filter the data to display January, February, and March sales. Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. Select Landscape orientation for all sheets.
Solved by V. B. in 11 mins
Click the Sales Information worksheet and convert the data to a table, name the table Sales, and apply the Table Style Dark 11. Type % of sticker in cell E1. Create a formula with structured references to calculate the percentage of the Sticker Price in column E. Format the range E2:E30 with Percent Style Number Format. Add a total row to display the Average of % of sticker and Sum of Sticker Price and Sale Price. AutoFit the width of columns B:E to show the total values. Apply Solid Fill Blue Data Bars conditional formatting to the % of sticker data. Select the range E2:E30 and create a new conditional formatting rule that uses a formula to apply yellow fill and bold font to values that sold for less than or equal to 70% of the sale price. On the First Quarter Sales worksheet, rename the table FirstQuarter. Filter the data to display January, February, and March sales. Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. Select Landscape orientation for all sheets.
Solved by Z. E. in 25 mins
Conditional formatting, I have two columns A and B with 50 different rows. Each row could have the same data, or different data. If a value in column A is present in column B I want to highlight that cell grey, if a value in column B is not in column A then I want to highlight that cell white.
Solved by K. W. in 26 mins