I would like to turn cell B1 red if any of the numbers in A2 to A10 are a negative. I am able to do this with one cell. For example if A2 is a negative it will turn B1 Red but am not sure how to get it to check a group of cells
I would like to turn cell B1 red if any of the numbers in A2 to A10 are a negative. I am able to do this with one cell. For example if A2 is a negative it will turn B1 Red but am not sure how to get it to check a group of cells
What formula do you have?
How about
=MIN($A$2:$A$10)<0
This will work as Conditional Formula in B1
=OR(A2:A10<0)
Forgot to upload my file.
Thank You, I made the MIN command work and also the OR. I did not know about OR. Thank you all for the help
You're welcome & thanks for the feedback.
Glad we both could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks