Hi there,

I'm a beginner at this, so apologies in advance for incompetence. . .

I have three columns, A, B, and C. Each column has over a thousand values of data manually inputted over time.

Column A can be 0, 1, or 2.

Columns B & C can have values of 99, 1, 2, or 3.

If Column A is 0, BOTH columns B & C need to have values of 99.

Step by step, how would I create a formula and use data validation to identify any spots in the data where A=0 but B&C are not 99.