Help with colour formula

B

bill gras

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?
 
M

Mike H

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
 
J

Jacob Skaria

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 Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula
=W1<>""

4. Click Format Button>Pattern and select your color (say Red)

5. Hit OK

PS: If you are using XL2007 Goto Home tab>Styles>Conditional
Formatting>Manage rules>New rule>Use a formula to determine which cells to
format. Enter the formula in the box below.
 
R

RonaldoOneNil

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top