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