| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number returns only two decimal places after I change from text | Excel Discussion (Misc queries) | |||
| Change number format from text to number? | New Users to Excel | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
| How do I change default font for all new comments in Office 2003? | Excel Discussion (Misc queries) | |||
Linear Mode
