specify a certain cell format as part of an "if" statement

  • Thread starter Thread starter Zeev Maoz
  • Start date Start date
Z

Zeev Maoz

How do I specify a specific cell format (e.g., scientific) as part of an if
statement?
 
Are you wanting to write VBA code (macro) to do that or did you want to do
this without code. The short answer is that it can not be done without code.
The closest you get is conditional formats which can modify cell formats, but
number formats are not included in the list of attributes accessable via
conditional formatting.
 

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

How to return formatting to cells rather than value for "IF" cmnd 2
Stop XL from changing format? 1
Number Formatting help 3
If statement with dates 0
Making the AND function look at only part of a cell entry 2
Excel 2007 bug? Merged cells must be formatted as scientific 2
Custom cell format for Scientific Notation 4
large numbers as text replaced with scientific notation 2

Back
Top