Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
conditional formatting with formula | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |