Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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
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


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.