change font color if number Range changes

G

Guest

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
 
G

Guest

Hi Moses,

use conditional format, change to "the formula is" and use
=or(f2<=70,f2>=120)

hth
regards from Brazil
Marcelo

"Moses" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing entire row based on 1 MAX cell value (Conditional Formatt 2
Logic Formula using colors in the formula? 2
Using Three Conditions in CF 3
How to use autofilter in excel with formula reference changing 1
how do i change row font color based on cell value in that row 5
If function with format 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
how I can Check the color of font in excel cell ? 2

Top