Conditional formatting multiple row selection based on cell value

Hello clever folk

I think I need help with adding multiple OR statements in Conditional formatting.

This is what I need:

I have a table from A1 - E20. Column A is numbered 1 - 20
I need something to select/highlight the row with lets say#5, 12, 18, 20.

I can do it setting a rule for each number but would like to just have one rule that looks for 5, 12, 18, 20 & highlights those rows.

Thanks

Each 'or' will have to be fully qualified:

It can't just be 'Value = 5 or 12 or 18 or 20'
it has to be 'Value = 5 or Value = 12 or Value = 18 or Value = 20'

The title of this thread should be improved following the rules of the forum and you will also get more traffic to the problem posed.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.


If this is what you are looking for, this is the formula in Conditional Formatting that will achieve this effect

Formula:

Please Login or Register  to view this content.

Capture.JPG

The active cell is always the key cell for Conditional Formatting. The range A1:E20 was selected as it was the range to be affected by the formatting then, the Conditional Formatting formula was applied.

The selection of the range replaces the statement A1:A20.
If you entered the formula =OR(A1:A20=5,A1:A20=12,A1:A20=18,A1:A20=20) the whole column A would be formatted. If you entered the formula =OR($A1:$A20=5,$A1:$A20=12,$A1:$A20=18,$A1:$A20=20) the whole range would be formatted. However if you entered the formula in the worksheet and produced TRUE and FALSE down a column (say column G) you could use a formula in Conditional Formatting like this and it will work if you selected A1:E20 and then entered the Conditional formatting formula.

Formula:

Please Login or Register  to view this content.

Instead of entering the range each time with the OR function, the formula could be shortened to the following filled down the column (G)

Formula:

Please Login or Register  to view this content.

The result on your worksheet would be like this. Capture 2.JPG

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.