Conditional Formatting for Excel XP.
 

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.

Conditional Formatting for Excel XP.
 

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

Conditional Formatting for Excel XP.
 

Thanx Genius!!!

"MyVeryOwnSelf" wrote:

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