Ask Your Question

Conditional Formatting

asked 2018-08-12 12:49:57 +0200

Clivo gravatar image

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 :)


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-08-12 13:40:47 +0200

kompilainenn gravatar image

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

edit flag offensive delete link more


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

kompilainenn gravatar imagekompilainenn ( 2018-08-12 13:41:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-12 12:49:57 +0200

Seen: 62 times

Last updated: Aug 12 '18