Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Help with colour formula
2 views
Skip to first unread message
bill gras
Jan 8, 2010, 6:09:01 AM1/8/10
to
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
=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
Mike H
Jan 8, 2010, 6:26:01 AM1/8/10
to
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
Jacob Skaria
Jan 8, 2010, 6:28:01 AM1/8/10
to
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
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.
--
Jacob
RonaldoOneNil
Jan 8, 2010, 6:31:03 AM1/8/10
to
Click on column W to select the whole column and then click the font colour
button and select Red.
button and select Red.
0 new messages