 |
 | 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 / January 2006how to change color of the cell if value changes
As the topic suggested I need help. Lets say I have a numeric value in cell B14 on Sheet3. The value i generated by COUNTIF from two other Sheets. What I need to do is change the color of the value when I chang something in the other Sheets to affect the value in B14 on Sheet3 Since I have like 50 cells which need to be checked it's just too annoying to do tha every time if the value has indeed changed or not. I think I need to use conditional formatting but I'm drawing a blan here. TIA t You need Conditional Formatting. Select column A Menu Format>Conditional Formatting Add a conditional test as appropriate Click the Format button Select the Pattern Tab Select an appropriate highlighting colour OK OK  SignatureHTH RP (remove nothere from the email address if mailing direct) > As the topic suggested I need help. > Lets say I have a numeric value in cell B14 on Sheet3. The value is [quoted text clipped - 10 lines] > > t. Maybe I'm still hung-over, or maybe I read the OP incorrectly, but I'd love to see your example of a conditional test that'll monitor a change in a cell, short of code.<g> SignatureRegards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- You need Conditional Formatting. Select column A Menu Format>Conditional Formatting Add a conditional test as appropriate Click the Format button Select the Pattern Tab Select an appropriate highlighting colour OK OK SignatureHTH RP (remove nothere from the email address if mailing direct) "kingu" <kingu.210m6y_1136218503.3032@excelforum-nospam.com> wrote in message news:kingu.210m6y_1136218503.3032@excelforum-nospam.com... > > As the topic suggested I need help. [quoted text clipped - 11 lines] > > t. http://www.excelforum.com/member.php?action=getinfo&userid=30058 > View this thread: http://www.excelforum.com/showthread.php?threadid=497364 |
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.