dynamic number format

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

Guest

I have a vlookup formula that will return different data based on a user
input. The data will either be a percentage or an integer. How can I
conditionally format the cell so that the number is formatted properly, or
that the vlookup returns the value and formats?
 
You can't use conditional formatting to change number format.

However, if all your percentages are non-zero and less than 1, you can
use Custom Format:

Format/Cells/Number/Custom...

[<=0]0;[<1]0.00%;0
 
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

vlookup formatting problem 1
Dynamic col_index_num in VLOOKUP? 5
Conditional formatting - sort of 4
VLOOKUP Returning a copy of a cell 1
VLOOKUP 2
IF OR AND in same conditional formula 2
Conditional Format Won't Update Cell 8
Weird prob: Format 3rd condition for other than first two 5

Back
Top