conditional formatting 2 colours for a cell.

[delboy1616]

Hello, I have a column that is conditionaly formatted. Cells change there fill colour depending upon the value. My cells change to red if the value <-0.1. Then green appears when the value>0.1 I have used rules type "cells that contain". but at the moment empty cells fill green. How can this be stopped with no fill.? my cell range is R4:R14
Many Thanks Del.

 

[DanteAmor]

Add New Rule.
Create conditional formatting rules with formula
- Select cells R14 through R14
- Then, click Home > Conditional Formatting > Manage Rules.
- The Conditional Formatting Rules Manager appears.
- click New Rule
- In the New Formatting Rule dialog box, click Use a formula to determine which cells to format.
- Under Format values where this formula is true, type the formula:

=ISBLANK($R14)

- Click Format.
- In the Color box, select None
- Click OK
- select the Stop If True check box
Note: Check that the new rule is up to the previous rules
- Click Apply
- Click Ok

 

[delboy1616]

Hi Dante, I tried this solution but the blank Cells did not change the fill colour. Is there anything else I could try?
Thanks

 

[DanteAmor]

Add another rule but in the formula put the following:

=$R4=""

 

[delboy1616]

Thanks Dante that fixed the issue thanks for you help and assistance.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.