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

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,199
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,108,844
Messages
5,525,186
Members
409,630
Latest member
Toby Corner

This Week's Hot Topics

Top