AnsweredAssumed Answered

Conditional Formatting of a calculation field

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


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