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

Hi,

Because your formula is returning a Null string for false these cells will
appear empty so why not select the column and format all cells as Bold & Red
then when the formula evaluates as TRUE you will get that font displayed.

Mike

"bill gras" wrote:

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

1. Select the cell/Range (say W1:W1000). Please note that the cell reference
W1 mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=W1<""

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK

PS: If you are using XL2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format. Enter the formula in the box below.

--
Jacob


"bill gras" wrote:

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

Click on column W to select the whole column and then click the font colour
button and select Red.

"bill gras" wrote:

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