How do I -> conditional required field?

[MAtkins]

Hi:

I'm simply trying to make a cell required (any text) if another cell in the same row is not empty.

Logic:

if A1 <> "" then G1 cannot be empty

I've hunted for hours so far and cannot find an answer.

[zbor]

Try in Conditional Formatting use =COUNTBLANK(A1:G1)>0 and you will see when you have blank cell in a row

[MAtkins]

Try in Conditional Formatting use =COUNTBLANK(A1:G1)>0 and you will see when you have blank cell in a row

Is there no way to just write a custom Validation code in Excel to do this?
I've gotta do this for a LOT of different cells.
I'd hate to have to write VBA code for it.

[galvinpaddy]

Hello,

What version of Excel are you running?
If 2007 or above can you not highlight the selection and click on Conditional formatting/Highlight Cells/more rules/ 'Change drop down to read BLANKS' and simply set the format?
Or have i misread?

galvinpaddy

[MAtkins]

Hello,

What version of Excel are you running?
If 2007 or above can you not highlight the selection and click on Conditional formatting/Highlight Cells/more rules/ 'Change drop down to read BLANKS' and simply set the format?
Or have i misread?

galvinpaddy

Well, I'm doing this for clients so it needs to work in multiple versions.

I originally thought I could just set a conditional validation in a cell basically:
=if(LEN(A1) > 0), LEN(G1) cannot = 0)

I really didn't want to turn this into a full blown VBA software application.
I just want to make a cell 'required' if another cell is not empty.

Apparently this is much more difficult than I expected.