Conditional Formatting
Hi,
I'm trying to format some cells so that: - if cell value is between -5 and 5, it formats the font Green - if cell value is between -6 and -20 or 6 and 20, it formats the font Yellow - if cell value is between -21 and -100 or 21 and 100, it formats the font Red Any assistance would be greatly appreciated. Thank you. |
Conditional Formatting
I got it!
"Judi" wrote: Hi, I'm trying to format some cells so that: - if cell value is between -5 and 5, it formats the font Green - if cell value is between -6 and -20 or 6 and 20, it formats the font Yellow - if cell value is between -21 and -100 or 21 and 100, it formats the font Red Any assistance would be greatly appreciated. Thank you. |
All times are GMT +1. The time now is 05:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com