Help using Conditional Formating of entire rows.

[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)

 

[Peo Sjoblom]

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

 

[Martin Smith]

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

 

[David McRitchie]

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

 

[Peo Sjoblom]

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

 

[David McRitchie]

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

 

[Martin Smith]

Thanks Peo and David for the quick replies. Really helpful!
Martin

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

One step further.....how can apply this to all other rows, without having to
specify the conditional formatting forumla to each row separately?