reference another cell in conditional formatting

  • Thread starter Thread starter Rose
  • Start date Start date
R

Rose

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
 
Change first box to "Formula is"
type:
=A2<1000
(A2 being whatever cell you want)
Select your formatting.
 
Rose said:
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
Click to expand...

It seems like that should work, but for some reason it is not. I think I
might have to rearrange the conditions.

Thanks so much!!
 
Luke M said:
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!*
Click to expand...

Luke,

I think I might have to rearrange my conditions. What you told me to do
seems like it should work, but it isn't. I will have to work on this later,
but I will let you know how it goes. (This is my first time using this
site). Thanks
 
Back
Top