Hi All, and thanks for adding me to the group
I’d like to put together a spreadsheet around vehicle weights, as follows:-
Column C will display legal maximum limit,
Column D will display actual weight (from weighbridge data),
Column E will show the difference between C & D [ =sum(D4-C4) ]
What I’d like to achieve is this.
If the value displayed in E4 is a positive value the text will show Red, if a negative value then show text in Green.
I’m far from expert in spreadsheets and don’t know how to define two different colours dependant on cell value.
Thanking you all in anticipation
Clivo