Hi Pawel, You can accomplish this simply by using conditional formatting.
You can either: 1. Use a default format and a conditional format. a. Format D5:J22 with one of the two formats. This would be your default format regarldess on the value in C2. b. Use a conditional format rule based on a formula. The formula would be =$C$2=1 (or $C$2=2) then set the appropraite format to go with the formula chosen. 2. Use two conditional format rules. a. one for the formula =$C$2=1 b. another form the formula $C$2=2 Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pawel lupinski Sent: Tuesday, July 03, 2012 1:34 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ range formatting Hi All, I'd hope that you'd help me on this one. I'd like to change range formating depending on the number in cell C2. So if I'll pick "1" formating for range D5:J22 should be change to britsh pounds like in "sheet2" So if I'll pick "2" formating for range D5:J22 should be change to formating like in "sheet3" Can you please help me on this? Thanks Pawel see attachment. -- 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 -- 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
