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.

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

Elsewhere on IDG sites

Xiaomi Mi 9 review

Apple has upgraded the iMac to make it twice as fast – and given the iMac Pro a quiet bump too

New iMac 2019 launch: Release date, price, features & specs

iMac 2019 : date de sortie, prix et fiche technique