is there a way I can put in a list of order numbers that I want highlighted with light red fill with dark red text if it appears in column B as opposed to going to conditional formatting>highlight cell rules>text that contains and typing in the order number for each one?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,803
- Office Version
- 365
- Platform
- Windows
Yes, you can put the list somewhere. Then you can use a COUNTIF formula in Conditional Formatting to see if an entry is found in your list.
For example, let's say that your list is in Z1:Z100, and you are checking the value in cell B1 to see if it is found in that list.
Then you can use the Conditional Formatting formula:
For example, let's say that your list is in Z1:Z100, and you are checking the value in cell B1 to see if it is found in that list.
Then you can use the Conditional Formatting formula:
Code:
=COUNTIF($Z$1:$Z$100,B1)>0
Upvote
0
Similar threads
