Conditional Formatting for Excel XP.

[Guest]

It is obvious how to use conditional formatting to highlight a cell a certain
color if the cell meets, exceeds or doesn't meet a certain criteria.

What I want to do is highlight that entire ROW. So if F9 = "Addressed" then
A9-F9 are highlighted (or even ALL of row 9).

Thank you in advance. You folks ALWAYS know everything and I appreciate you
for it.

 

[MyVeryOwnSelf]

It is obvious how to use conditional formatting to highlight a cell a

certain color if the cell meets, exceeds or doesn't meet a certain
criteria.

What I want to do is highlight that entire ROW. So if F9 =
"Addressed" then A9-F9 are highlighted (or even ALL of row 9).

One way:

In A9 use conditional formatting with the formula
=$F9="Addressed"

Copy cell A9.

Select the area of the sheet to be affected and use
Edit > Paste special > Formats

 

[Guest]

Thanx Genius!!!

One way:

In A9 use conditional formatting with the formula
=$F9="Addressed"

Copy cell A9.

Select the area of the sheet to be affected and use
Edit > Paste special > Formats