Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |