Hi, how to conditional format for a changed alpahnumerical cell value? is it possible? if i have a filled worksheet where tb3 is value in cell A1 and *tb4 is value in cell A2* and I change cell *A1 value to tb4* the "macro" would *change only cell A1 background*. It *shouldn'*t change cell A2 value I think this is not possible with conditional formatting. conditional formatting will highlight all cells with some condition i want to highlight only cell which has a changed value... Please help me in this regard Best regards Vijay yadav
On Wednesday, 4 July 2012 11:04:32 UTC+5:30, Annu wrote: > Dear Vijay, > > For this you may use conditional formatting. There is no need to make > macro. > > > Thanks & Regards, > Gawli Anil > > On Wed, Jul 4, 2012 at 11:00 AM, vijay yadav <> wrote: > >> Hi Members / Experts >> >> I need a macro to change the background color of a cell as soon as i >> change the value (alphanumeric). >> The background is originally yellow and as soon I change a value it >> should become no fill (or white ). >> >> Sometimes the changed value might be same as previous value ..in that >> case what should be done so that the >> background color changes to white ? >> like should I enter the cell and write the value again or any other option >> >> Please help me in this regard >> >> Vijay yadav >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
