I am having a problem with formatting some cells. I am
putting two different kinds of units in a column that auto
fills. That is, I have an =if(...,true,false) formula.
my problem is that I have different units for the true
values from the false values. I tried to find a
conditional format that might work, but then realized that
the option does not include a conditional format for
numeric values...I was wondering if Excel has any way of
formatting one way for a true value and another way for a
false value. That is, I want the true value to be a
percentage, and the false value to be a number with two
decimals. Can Excel do that?
Thank you for your time,
Andrea