Hi allI'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 REDIf the miles per gallon that is returned is greater than 40MPG turn the text colour to green.Any ideas?ThanksNeil.
Take a look at Conditional Formatting click here
This thread is now locked and can not be replied to.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?
© Copyright 2017 IDG UK. All Rights Reserved.