Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
CAN ANYONE HELP ME!!!!
I need to change the colour of the font when a value is greater or less than for example; the value there should be is 5, if the value is 4 then the text should say (order now) in red font, which i have managed to achieve using the following formula; =IF(B8C8,"ORDER NOW!!") the problem is.... if the value is more than 5 the text displays FALSE, although the writing is still in red, and i cant find a formula that will let me change this!!! If anyone can help it would be much appreciated Thankyou Natasha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change font colour | Excel Discussion (Misc queries) | |||
Change font colour | Excel Discussion (Misc queries) | |||
Change font colour | Excel Discussion (Misc queries) | |||
Change font colour for whole row | Excel Worksheet Functions | |||
font colour change within a IF formula - Help!! | Excel Worksheet Functions |