Carl Clements
Board Regular
- Joined
- Jun 13, 2008
- Messages
- 95
Hi,
I'm applying some conditional formatting to a column, which highlights cells if a number is >10 or <-10, however, it also formats cells with text (eg headers).
Firstly, does anybody know why it is formatting text, and secondly, how I can avoid it so it looks at numbers only?
Thanks,
Carl
I'm applying some conditional formatting to a column, which highlights cells if a number is >10 or <-10, however, it also formats cells with text (eg headers).
Firstly, does anybody know why it is formatting text, and secondly, how I can avoid it so it looks at numbers only?
Thanks,
Carl