How to allow a specific group of value can be input?

[silvermoon]

Hi all,

I would like to ask how to allow a specific group of value can be input, otherwise the value in the cell turned red.

For example,
Cell A1 allow the group value 100-150 and 180-220, otherwise turn that value into red color.

It's okay to input 101, 149, 192, 201; but 99, 174, 152 will turn red

Cheers
Edward

[teylyn]

Hello,

you can use conditional formatting for that. Select A1, then click Format > Conditional Formatting and specify that you want to use a formula. Then enter this one:

=or(and($A$1>=100,$A$1<=150),and($A$1>=180,$A$1<=220))

Select a format and close the dialogs

cheers,

[silvermoon]

Thank you so much! It works :D

[teylyn]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save