delboy1616
New Member
- Joined
- Aug 31, 2015
- Messages
- 21
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.
Many Thanks Del.