Excel 2003, Validation across range

[network_engineer]

Hi all,

Could somebody guide me on this please?

How would I ensure that only one cell across a range could be filled? E.g.

across five horizontal cells, say A1:E1, I want to restrict that only one of those cells may be filled. I.e. if A1 is filled (with text or numbers), then B1, C1, D1, and E1, may not be filled.

Optionally, would be great if A1 is filled, all the others B1:E1 would be grayed out.

Kind regards!

 

[Peter_SSs]

Your first row also seems to keep changing. Is your first row 1 or row 4?

 

[network_engineer]

Hi!

Sorry! It is 4. C4 through E4. But the formula you gave me earlier worked. Thanks!

Kind regards.

 

[Peter_SSs]

So you are right for both the Data Validation and the Conditional Formattingt shading now?

 

[network_engineer]

Yes Peter! Thanks! Appreciate the help!

If I may request, there is another thread that I just opened, separate topic, would help some input there too.

Kind regards,
Ben