MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Jane on October 24, 2001 5:24 PM

Is it possible to apply conditional formatting to an entire row of cells.
Eg. I have a data table. If one of the cells in a specific column contains the word "economy" i'd like the entire row to be shaded. I can only seem to apply the conditional formatting to the single cell which contains the word "economy".


Posted by Tom Urtis on October 24, 2001 6:18 PM

Try this


(1) Click in the cell where your data starts (for instance A2 if row 1 contains headers and your data starts in column A).

(2) From the worksheet menu bar, click on Format > Conditional Formatting.

(3) Under where you see "Condition 1", click the little down arrow to choose and display "Formula Is".

(4) Let's say the specific column that might contain the word "economy" is column C. In the white box to the right of "Formula Is", enter this formula: =$C2="economy" Note the absolute reference for column C and relative reference for row 2.

(5) Click the Format button, then choose whatever formatting you want to alert you when "economy" exists, and click OK.

(6) Now back onto your worksheet, copy cell A2, and Paste Special Formats to all the other cells in your range.


Tom Urtis