Excel formatting

J

Jayne

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.
 
N

Norman Harker

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.
 
T

Tom Ogilvy

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
=$F10>10
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.
 
Top