Excel conditional formatting

[Nikhil2803]

Hi Team,

I am working on the below request. If someone misses value in column A, and directly put values in col C, it will alert that col A is required. for Column C my conditional formatting code is

=AND(D$4=1,NOT(ISBLANK($B5)),ISBLANK(D5))

Now the ask is while entering Last Name(col C), it should check either of Col A or col B should have values. could you please help how to validate that.

 

[dreid1011]

For Data Validation in column C, you could use a custom data validation rule like this:

=OR($A5<>"",$B5<>"")