graemeal
Active Member
- Joined
- May 17, 2007
- Messages
- 316
- Platform
- Windows
In column J I have the following formula =IF(AND(C2<0.25,C2>-0.1),C2,0)
In conditional formatting (or by any other means) I would like to fill the J column cell "red" if values are between 0.25 and -.01, EXCLUDING any cell with zero in it.
I am stumped with how to exclude colouring the cell red if a zero is present.
Thank you
In conditional formatting (or by any other means) I would like to fill the J column cell "red" if values are between 0.25 and -.01, EXCLUDING any cell with zero in it.
I am stumped with how to exclude colouring the cell red if a zero is present.
Thank you