How do I keep the format of a cell that an if statment refers to?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using an if statemnt and the result if true points to one cell with
special formats and another cell if false with other formats. The result
shows the correct value, but I'm more interested in the font because I'm
using different symbols from various fonts.
 
Formulas return values--not formats.

Maybe you could use some other way--like a worksheet event that actually does a
copy|paste???
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about conditional formatting of zeros in Excel 0
& to combine cells/Keep formats 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
inserting a hyperlink into a conditionally formatted cell, Excel 2 2
how do I start a macro using If Then statments 2
Conditional Formating: linking to display another cell 3
HDMI is a terrible format and I wish it never existed 2
How do I use a relative cell reference that will copy the format? 4

Back
Top