Conditional Formatting

[Clivo]

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

[kompilainenn]

Yoy should set two conditions for your range.

1. Value is - more - 0 and set style for it - Bad

2. Value is - less - 0 and set style for it - Good

And what do you do if value in E4 will equal 0? In this case you should set third condition Value is - equal - 0 and set style for it as you like

[kompilainenn]

To add several condition to your range push button Add in dialogue Conditional formatting for…