Re: Conditional formating, values.

Hi Bob,

Thank you for your reply.
I tried back and forth in making a new condition, and couldn't make it work
.... and then suddenly it worked!! :o)
Thanks a lot for your help.


/Kasper




"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:eX9Pw3zzFHA.2064@xxxxxxxxxxxxxxxxxxxxxxx
> Kasper,
>
> It should be simply achieved by creating a condition of less than or equal
> to -10000. The trick is to ensure that that is the first condition, other
> the yellow will take effect and that condition will not be tested.
>
> --
> HTH
>
> Bob Phillips


.

Relevant Pages

  • Re: Totaling Months
    ... HTH ... Bob Phillips ... > I have 3 columns in my worksheet, column F Date Due, column G is Date ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: excel sorting task
    ... HTH ... Bob Phillips ... > I have the following data in a worksheet ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: nested formula with if condotion
    ... HTH ... Bob Phillips ... > can anybody helpme out to put formula using if or any other ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do I make a column of checkboxes quickly?
    ... HTH ... Bob Phillips ... > I have a list of people my company has already mailed letters to (about ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Use % as variable for user id?
    ... "Roger Govier" wrote: ... > the use of Environ variables elsewhere whilst researching something ... >> HTH ... >> Bob Phillips ...
    (microsoft.public.excel.programming)
Loading