Thanks:  0
Likes:  0

# Thread: A Nice Easy One (Hopefully!)

1. I want to apply conditional formatting to a cell so that it is filled in red if the value is above a set value (9.6). Easy enough. However, when using the "Greater Than" condition, the cell is formatted if it has no value entered. How do I stop this happening?

2. I could not duplicate this happening (blank did not trigger conditional formatting). Are you sure the cell is otherwise empty?

3. Nick greater than 9.6 works for me, anything above 9.6 changes the cell condition anyhing under does not

On 2002-03-14 07:25, Mr Nick wrote:
I want to apply conditional formatting to a cell so that it is filled in red if the value is above a set value (9.6). Easy enough. However, when using the "Greater Than" condition, the cell is formatted if it has no value entered. How do I stop this happening?

4. It contains a formula:

=IF(G12="","",IF(G12="FIXED POWER",SUM(((T12*C12*K12)/1000)+U12),IF(G12="LIGHTING",SUM(((T12*C12*K12)/1000)+U12),IF(G12="RING MAIN",SUM(((T12*C12*K12)/4000)+U12),"Cct Type!"))))

Which, if certain cells are not filled in, leaves this conditionally formatted cell blank. If it left blank, the cell gets formatted but if value is entered above 0 the formatting works. I've tried adding a second condition for a zero value but this doesn't work either??

5. [quote]
On 2002-03-14 07:25, Mr Nick wrote:
I want to apply conditional formatting to a cell so that it is filled in red if the value is above a set value (9.6). Easy enough. However, when using the "Greater Than" condition, the cell is formatted if it has no value entered. How do I stop this happening?
[Hi Mr Nick,
You require to set the first value on the conditional formatting equation to equal 9.6 = no format and then set a second condition of greater than

]

6. That doesn't work. It still formats the cell in red if it is blank.

7. Just select

"Formula is"

in conditional formatting then use this for formula

=AND(ISNUMBER(B3),B3>9.6)

(=AND(ISNUMBER(B3);B3>9,6) if you are using , for decimal seperator in your system)

B3 is the cell reference

regards
suat
(You can visit TheWordExpert for VBA help and also other office applications)

[ This Message was edited by: smozgur on 2002-03-14 08:02 ]

8. You might try setting the conditional formatting to Formula Is =(your formula)>9.6

9. Smozgur - That's done it.

Cheers Everybody.

10. Nice to hear that

suat

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•