Give Color to negative number
in [Project]
|
From: Rohan on 15 May 2008 08:05 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
From: Jack Dahlgren on 15 May 2008 09:41 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(a)discussions.microsoft.com> wrote in message news:C5F80CCA-9064-4C8E-B2B2-A953B8A20C2A(a)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
From: Rohan on 15 May 2008 09:53 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(a)discussions.microsoft.com> wrote in message > news:C5F80CCA-9064-4C8E-B2B2-A953B8A20C2A(a)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 > > >
From: Jack Dahlgren on 16 May 2008 13:50 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(a)discussions.microsoft.com> wrote in message news:689CAC91-FADA-42BB-9C7B-2653577950A7(a)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(a)discussions.microsoft.com> wrote in message >> news:C5F80CCA-9064-4C8E-B2B2-A953B8A20C2A(a)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 >> >> >>
From: Rohan on 19 May 2008 05:02 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(a)discussions.microsoft.com> wrote in message > news:689CAC91-FADA-42BB-9C7B-2653577950A7(a)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(a)discussions.microsoft.com> wrote in message > >> news:C5F80CCA-9064-4C8E-B2B2-A953B8A20C2A(a)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 > >> > >> > >> > > >
|
Pages: 1 Prev: Using Baseline1 in Project Statistics Next: summary projects in a top level paln |