View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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