How to condition in excel 2007?

**pumpkin1** · 03-05-2012, 10:20 PM

Hi,

Im new here. Wonder if anyone can help me on this.

How to condition excel if fill up column D (from cell D9 to D50), automatically column E & column F(from cell 9 to 50), will be black color and cell will be disable?

Thanks in advanced.

**FDibbins** · 03-05-2012, 11:42 PM

The conditional formattin sounds pretty easy to do, in conditional formatting, select "use a formula/new rule, and add...

=COUNTA($D$9:$D$50)=42 format the the font and fill to black

but what do you mean by "disable"?

**pumpkin1** · 03-06-2012, 12:12 AM

thanks FDibbins.

What i mean by disable is to lock the cell so that the cell cant be input.

**pumpkin1** · 03-06-2012, 02:41 AM

Actually to be honest, im not sure what are tools to help me getting this result as below:

1) If any cell in column 'A' is fill up with anything, automatically any cell in column 'B' and column 'C' will be blackout and locked (not allow any input)
A B C
xxxx

2) If any cell in column 'B' or/ and 'C' is fill up with anything, automatically any cell in column 'A' will be blackout and locked (not allow any input)
A B C
xxxx xxxx

**FDibbins** · 03-08-2012, 08:26 AM

Why do you want to "lock"/protect B and C if anything is entered in A? To protect a cell the way you want will take an event macro VBA (i think) which is not something I and very good at yet