Excel formulas - text colour

  theearlofsabden 13:05 01 Aug 2010
Locked

Hi all

I've set up a petrol spreadsheet that converts litres to gallons etc but in the last column "miles per gallon" I want to record two vaules....

If the miles per gallon that is returned is less than 40MPG turn the text colour to RED

If the miles per gallon that is returned is greater than 40MPG turn the text colour to green.

Any ideas?

Thanks
Neil.

  VoG II 13:08 01 Aug 2010

Take a look at Conditional Formatting click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?