AnsweredAssumed Answered

Conditional Formatting of a calculation field

Question asked by brianj77 on Aug 7, 2015
Latest reply on Aug 17, 2015 by erolst

Hi

This sounds a really dumba__ question for  really basic facility which I can’t seem to get to work

 

I have a ‘Time Sheet’ type application

 

The time sheet  has two fields with number (hours) and a third calculating the difference between the two (positive or negative).

 

The calculation field simply subtracts field B from field A to display an integer

 

I need the calculation field to simply display the calculation result (number) but also with some conditional formatting with the following logic

 

If A=B - then no action: display the number in default state

If A-B is positive then display the number in colour green and bold

If A-B is negative then display the result in colour red and bold

 

I cant get a way to make this simple requirement work and its driving me crazy: such a simple facility.

 

Can anyone please point me in the right direction

 

Thanks for your help. I appreciate you taking the time to read this and answer my question

Brian

Outcomes