change font color if number Range changes
Hello,
I have a number in cell B1 that is a pasted link from a different worksheet. I want the font color in cell B1 to change depending on what value is displayed in B1. If <70 RED Bold, If 70 to 120 Automatic, If 120 Red Bold |
change font color if number Range changes
Hi Moses,
use conditional format, change to "the formula is" and use =or(f2<=70,f2=120) hth regards from Brazil Marcelo "Moses" escreveu: Hello, I have a number in cell B1 that is a pasted link from a different worksheet. I want the font color in cell B1 to change depending on what value is displayed in B1. If <70 RED Bold, If 70 to 120 Automatic, If 120 Red Bold |
All times are GMT +1. The time now is 12:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com