 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2005Conditional Formatting of a row
I want to use Conditional Formatting to color a row (or 10 cells across) based on the value of one cell. If the specific cell value is "W" I want the row colored green. If it is "D" I want the row red, and so on according to my rules. I know it can be done 'cause I did it on an old workseet, but I don't have it anymore. Any suggestions? Tx, Ian If you want A1:A10 to turn green based on a value of "W" in B1: Highlight A1:A10 then in the conditional formating options choose "formula is" instead of "cell value is" from the drop down menu and enter "=$B$1="W", then choose the green background pattern. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.