Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formatting
Hi Jayne!
Taking Row 29 as an example: Select the row by clicking the Row Number Format Conditional Formatting Formula Is =$A$29=17 Format Button Select format to taste OK OK Now enter 17 in A29 and you'll see that the format applies to the whole row. -- Regards Norman Harker MVP (Excel) Sydney, Australia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting lost when saving excel 2003 file using excel 2007 | Excel Discussion (Misc queries) | |||
"Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Please re-check your formatting carefully." | Excel Discussion (Misc queries) | |||
Saving Excel 2007 conditional formatting in Excel 2003 format | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |