Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
Can I use the IF function to change the colour of a font? I'm using an IF
statement to subtract one time from another giving a positive answer. Another in the cell below to tell me if the subtraction of the two times is over or under zero but I'd like to highlight, automatically if it's below zero by changing the font colour to red. Trouble is the IF statement would referance it's own cell. Is it possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
It's much simpler to use conditional formatting. Select cell click format -
conditional formatting and the rest is fairly intuative. "Bikertyke" wrote: Can I use the IF function to change the colour of a font? I'm using an IF statement to subtract one time from another giving a positive answer. Another in the cell below to tell me if the subtraction of the two times is over or under zero but I'd like to highlight, automatically if it's below zero by changing the font colour to red. Trouble is the IF statement would referance it's own cell. Is it possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
Works a treat. Thanks very much.
"Mike" wrote: It's much simpler to use conditional formatting. Select cell click format - conditional formatting and the rest is fairly intuative. "Bikertyke" wrote: Can I use the IF function to change the colour of a font? I'm using an IF statement to subtract one time from another giving a positive answer. Another in the cell below to tell me if the subtraction of the two times is over or under zero but I'd like to highlight, automatically if it's below zero by changing the font colour to red. Trouble is the IF statement would referance it's own cell. Is it possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |