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

You'll need to set two conditions:

Formula is: Self < 0 [ bold and red ]

Formula is: Self > 0 [ bold and green ]