Help using Conditional Formating of entire rows.

  • Thread starter Thread starter SMonczka
  • Start date Start date
S

SMonczka

I would like to know how to format an entire row using conditional
formatting based on the contents of one cell in that row.

In other words if A1 is equal to "$450.00" then high light row A using
red.

If anyone might know the answer to that one please let me know.

Thanks.

S. Monczka
(e-mail address removed)
 
Select the whole row, do format>conditional formatting,
select formula is and use

=$A$1=450

or in case the value is text

=$A$1="$450.00"

most likely it's the first formula, then click the format button and select
the pattern and click OK twice
 
One step further.....how can apply this to all other rows, without having to
specify the conditional formatting forumla to each row separately?

Cheers,
Martin
 
Hi Martin,
Select all of the sheet (Ctrl+A)
and use the formula: =$A1=450

That means that every cell will be tested
with that formula. That also means that every cell has used
up one of the three conditions allowed per cell. And doing
them all at once should be much more efficient than assigning
them one row at a time.

Formula is based on the active cell so A1 should be
the active cell when entering formulas in Format, C.F>
and the area involved for coloring cells is the selection area.

More on Conditional Formatting on my page:
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
 
If you mean if the any cell in column A equals 450, format that particular
row?

Select from the whole row from row 1 with A1 as the active cell then use

=$A1=450

note the absolute/relative reference
 
I got back message no longer available on server for my
reply so I'm resending it, trimming it too. -- David

===========================
Hi Martin,
Select all of the sheet (Ctrl+A)
and use the formula: =$A1=450

That means that every cell will be tested
with that formula. That also means that every cell has used
up one of the three conditions allowed per cell. And doing
them all at once should be much more efficient than assigning
them one row at a time.

Formula is based on the active cell so A1 should be
the active cell when entering formulas in Format, C.F>
and the area involved for coloring cells is the selection area.

More on Conditional Formatting on my page:
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
 
Back
Top