Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Can i have a formula that formats a cell in function of another cell value. Lets say, if A1=1 all the values in column B are formatted into dollars. If A1 different than 1 then all the values in column B are formatted into Euros!

share|improve this question

1 Answer 1

Sure, use conditional formatting.

  1. Select column B and go to Conditional Formatting;
  2. Click on 'New Rule' and pick the last option 'Use formula ...'
  3. In the input box, put =$A$1=1 and pick the format as 'Number' > 'Currency' > 'Euro' (well, the currency you want)
  4. Click OK twice.
  5. Repeat steps 1-4 but with the other formatting, 'Dollars' and the formula now =$A$1=2.

And there goes the magic :)

share|improve this answer
1  
Well explained. Nice answer. –  CharlieRB Aug 21 '13 at 17:34
    
Thank you @CharlieRB :) –  Jerry Aug 21 '13 at 17:38
    
Thank you so much. It works perfectly!!! Really appreciate it. –  Xavier Cunha Aug 21 '13 at 18:48
    
@XavierCunha You're welcome :) –  Jerry Aug 21 '13 at 18:53
    
@XavierCunha if this answers your question please mark it as the answer. –  teylyn Aug 21 '13 at 21:29

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.