Looking for how to do Conditional Formatting for the following rule:
If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. Both cells will turn RED until this is completed.
Material # Batch Fill Line # 83716 UP1278 1 83715 UP1284 3 83704 UP1287 4 53716 UP1255 2 26415 UP1291 12 26415 UP1293 12 56160 UP1257 10
When the cell in the
Material # column contains the number 53716, 26415, or 56160, then this cell will turn RED as well as the cell on the same row that is in the
Fill column. BOTH cells will remain the color RED until the cell in the
Fill column has data typed into it.
How should I set up conditional formatting for this when I want to do it for different numbers?
How do I make my list of this # or this # or this # or this # .......... and have the cells in both columns respond to the particular numbers by BOTH turning RED in color until the
Fill column cell has data information typed into it?