Good Day Folks:
Is data validation a good solution for the following or should I try code?
I have a production schedule and based on the color change sequence on items going down the worksheet, I want to provide an error message (warning, not a hard stop) to prompt that a "Purge" is required. Need soft message only, no auto-population of data is required. Have done this in the past with an =IF formula and text message in the worksheet but a recent change in the layout by Production now makes this problematic.
Previous worksheet formula that worked fine:
=IF(B6="Red",IF(AND(B8<>"Black",B8<>"Red"),"Purge",""))
Stepping down the production schedule worksheet:
If B6=Red and (skips one row for each item)
If B8=Black or Red, then nothing/OK
If B8<>Black or Red, then "Purge" is required (need warning message)
Repeats and can expand to about 30 rows total with color sequence changing constantly.
Not familiar with DV and have not gotten a formula to work with my first few attempts, so any assistance would be appreciated.
Thx,
DEF98