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
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
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks