Re: Give Color to negative number by Rohan
Rohan
Mon May 19 04:02:02 CDT 2008
Thank you Jack,
Ill see what i can do.
Kind Regards,
Rohan
"Jack Dahlgren" wrote:
> There is a predefined cost variance field which will show the difference
> between baseline cost and cost. Why not just display that?
>
> Then use a custom field, set the value to the cost variance field and use a
> graphical indicator for it.
>
> Steps:
> Insert a column (I'd probably try a text field)
> Right click the column header and select customize
> Rename the field if necessary
> click the formula button
> go to the "field" drop down and choose cost variance
> click OK
> click the "Graphical Indicators" button
> set the criteria and indicator the way you want
> click ok
> click ok
>
> I think your client is mistaken about comparing actual cost to baseline
> cost. Actual cost is going to be less than Baseline most of the time if the
> task is not completed. They should use cost instead. Cost = actual cost +
> remaining cost. Actual cost is only accrued cost.
>
> -Jack Dahlgren
>
> "Rohan" <Rohan@discussions.microsoft.com> wrote in message
> news:689CAC91-FADA-42BB-9C7B-2653577950A7@microsoft.com...
> > Thank you very much.
> >
> > I was looking for hours on the forum for a solution:)
> > anyway you have any other suggestion for me.
> >
> > I shall explain what the client wants.
> > they have two colums.
> > 1 with baseline cost and the other1 with Actual coast.
> > in the 3th column they want the difference between baseline cost - actual
> > cost.
> > and when the result is negative it should turn "Red" and 'green' for
> > positive.
> >
> > Do you have some other suggestion for me what i can do.
> >
> > Kind regards,
> >
> > Rohan
> >
> >
> >
> >
> >
> > "Jack Dahlgren" wrote:
> >
> >> Sorry, that sort of conditional formatting can not be done. You could
> >> display an indicator which could be read or green or the result, but not
> >> both in the same field. Also you can't control the text color in a cell
> >> using a formula.
> >> You could use a macro to do this, but you would need to run the macro
> >> whenever you wanted it to calculate.
> >>
> >> If you need the red and green and also the result, make two fields which
> >> each have the same formula. Use one for the result and the other for the
> >> graphical indicator,.
> >>
> >> -Jack Dahlgren
> >>
> >> "Rohan" <Rohan@discussions.microsoft.com> wrote in message
> >> news:C5F80CCA-9064-4C8E-B2B2-A953B8A20C2A@microsoft.com...
> >> > Hello everyone,
> >> >
> >> > I have a question about a formula.
> >> > I have 3 colums, lets say A, B and C (in C we have the result of A-B).
> >> > what I want is:
> >> >
> >> > When A-B= negative number it should turn Red and when its positive it
> >> > must
> >> > be green.
> >> >
> >> > I hope someone can help me.
> >> >
> >> > Kind regards,
> >> >
> >> > Rohan
> >>
> >>
> >>
>
>
>