Thread: Formatting
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default 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.