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.
For example,
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?
No comments:
Post a Comment