Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In column W row 2 I have a formula eg:
=IF(AND(L2<=5,V2<=7.1),V2,"") copied down to row 1001 not every row has a result , lots of rows are blank . The numbers in column W need to be in red font L V W 2 6.6 22.4 3 0.4 18.3 4 2.0 9.7 5 6.8 0.2 6 2.6 5.1 5.1 7 -0.5 16.3 8 0.2 -4.5 -4.5 and so on Can some one help me with this please? -- bill gras |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using colour within a formula | Excel Discussion (Misc queries) | |||
colour in a formula | Excel Discussion (Misc queries) | |||
formula for colour | Excel Worksheet Functions | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
Text in Blue colour, but print in black colour | Excel Worksheet Functions |