Default value in CF Excel 2007
Not sure I understand what you mean by a default value.
In conditional formatting, your formula bar is blank. If you click the
drop-down box, you may see a value such as the amount in the cell you are on,
but that isn't required. You should be able to just enter the values you
desire.
"theIThombre" wrote:
Hey gang,
I am setting up CF on a list of numbers. However, after I apply my first
rule(ex. greater than $10,000) and go back to set a second rule or icon, I
get a default value. In my case, it's $7422 and it throws off my entire cf. I
have deleted all of my spreadsheets cf rules and I still get that amount.
What's worse is that even after I type in a rule, future CF follows the
default amount and not mine.
Why is CF doing this?? Is there a way to stop the default value from coming
up?
Thanks
--
The IT Hombre
|