Excel formatting
I am trying to get an entire row to highlight when a
certain cell in the row equals something. Is this possible? I know how to get the individual cell to highlight, just not the whole row to apply to the one cell. Thanks. |
Excel formatting
I assume you are using conditional formatting.
Select the whole row with the cell in column A as the activecell Assume the trigger cell is F for illustration purposed, assume we are working on row 10 and if F10 is greater than 10, we will change the color of the row with the row 10 selected and A10 as the activeCell (reverse highlight) Format=Conditional Formatting Change the Cell Value is to Formula is in the first dropdown in the text box put in the formula =$F1010 then click the format button, select the pattern tab, select your highlight color, then OK out of conditional formatting. If you want to format several rows this way, just select all the rows and write the above formula for the row that has the active cell. The row is relative in the formula, so it would adjust for each of the selected rows. The column is absolute, so each cell would be formatted according to the value in that column (F in the example) for the particular row. -- Regards, Tom Ogilvy "Jayne" wrote in message ... I am trying to get an entire row to highlight when a certain cell in the row equals something. Is this possible? I know how to get the individual cell to highlight, just not the whole row to apply to the one cell. Thanks. |
All times are GMT +1. The time now is 01:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com