Change first box to "Formula is"
type:
=A2<1000
(A2 being whatever cell you want)
Select your formatting.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Rose" wrote:

I have used the first two options. For the third one I want to say if cell
whatever (not the one I am conditionally formatting) is less that (1000) then
fill in red