Wednesday, October 11, 2017

microsoft excel - Conditional Formatting for one cell value in a list, another cell blank

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

hard drive - Leaving bad sectors in unformatted partition?

Laptop was acting really weird, and copy and seek times were really slow, so I decided to scan the hard drive surface. I have a couple hundr...