Formatting
 

Not sure of the name of what it is I want to do:
If cell E1 has a specific value, then I'd like to format cells A1:E1 in a
specific manner. My worksheet has 15,000+ rows and I'd need to have this
function/formatting/? follow through the entire sheet.

Formatting
 

Checkout conditional formatting in Excel Help.
--
Gary's Student
gsnu200701


"SPC" wrote:

Not sure of the name of what it is I want to do:
If cell E1 has a specific value, then I'd like to format cells A1:E1 in a
specific manner. My worksheet has 15,000+ rows and I'd need to have this
function/formatting/? follow through the entire sheet.

Formatting
 

Conditional formatting only changes the formatting in one cell (the cell with
the condition you've specified) - right? If it changes cells in addition to
the one you've set the condition, I can't figure out how to tell it to.

"Gary''s Student" wrote:

Checkout conditional formatting in Excel Help.
--
Gary's Student
gsnu200701


"SPC" wrote:

Not sure of the name of what it is I want to do:
If cell E1 has a specific value, then I'd like to format cells A1:E1 in a
specific manner. My worksheet has 15,000+ rows and I'd need to have this
function/formatting/? follow through the entire sheet.

Formatting
 

Select columns A through E.
Select Format - Condition Formatting
Select "Formula Is" and enter this formula
=$E1=12
*be sure to include both equals signs.
replace 12 with the "specified" value required.

"SPC" wrote:

Not sure of the name of what it is I want to do:
If cell E1 has a specific value, then I'd like to format cells A1:E1 in a
specific manner. My worksheet has 15,000+ rows and I'd need to have this
function/formatting/? follow through the entire sheet.

Formatting
 

Thank you Gary's Student and Sloth!!!
Works like a charm.

"Sloth" wrote:

Select columns A through E.
Select Format - Condition Formatting
Select "Formula Is" and enter this formula
=$E1=12
*be sure to include both equals signs.
replace 12 with the "specified" value required.

"SPC" wrote:

Not sure of the name of what it is I want to do:
If cell E1 has a specific value, then I'd like to format cells A1:E1 in a
specific manner. My worksheet has 15,000+ rows and I'd need to have this
function/formatting/? follow through the entire sheet.