Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel - Conditional Formatting 1
- Thread starter Jock1970
- Start date
-
1
- #2
Yes.
(Ex: Select cell A1. Format > Conditional Formatting > "Formula is" > =C1>5, Format..., choose Patterns, choose blue color, OK. If the number entered into cell C1 > 5, A1 will turn blue)
Tired of waiting for an answer? Try asking better questions. See: faq222-2244
(Ex: Select cell A1. Format > Conditional Formatting > "Formula is" > =C1>5, Format..., choose Patterns, choose blue color, OK. If the number entered into cell C1 > 5, A1 will turn blue)
Tired of waiting for an answer? Try asking better questions. See: faq222-2244
Highlight the cell you want ot have the conditional formatting. Goto the Format>Conditional Format menu. Change the first dropdown to "Formula is" If you wanted, for instance, to change the format if cell C1 is greater than 10 you would enter =$C$1 > 10 Then set the format the way you wnat it by clicking the format button.
Sam
Sam
- Thread starter
- #4
- Status