Maybe a longshot - Cell Format Depending On Value In Another Cell

glerwell

Well-known Member
Joined
Jun 25, 2006
Messages
1,080
Hi

I think this is a longshot but excel is a powerful tool so its worth a try.

Would it be possible to set a the format of one cell (A1) depending on whats in A3.

So if A3 equals "A" then then format would be "0.00"
if A3 equals "B" then the format would be "###/###" (fraction)

Thanks
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,211
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hi

I think this is a longshot but excel is a powerful tool so its worth a try.

Would it be possible to set a the format of one cell (A1) depending on whats in A3.

So if A3 equals "A" then then format would be "0.00"
if A3 equals "B" then the format would be "###/###" (fraction)

Thanks
You could use conditional formatting:
First format cell A1 as General. Then use two conditional format rules as follows: (1) select cell A1 and apply the format rule
=A3="A" with a number format "0.00", (2) select cell A1 and apply the rule =A3="B" with a fractional format "# ???/???"
 
Last edited:

glerwell

Well-known Member
Joined
Jun 25, 2006
Messages
1,080
Thanks guys!

Gone with the conditional formatting, didn't think of that!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,084
Messages
5,526,755
Members
409,717
Latest member
Oscarsalone

This Week's Hot Topics

Top