Conditional formatting

[Lewis]

I want to set up a sheet so that if I put data in Column A then I get a border round the cell AND the cells in the same row in columns B and C

Any suggestions

 

[Mark W.]

Do you want a border around each of the 3 cells or a single border around all 3 of the cells?

 

[Aladin Akyurek]

On 2002-03-01 08:13, Lewis wrote:
I want to set up a sheet so that if I put data in Column A then I get a border round the cell AND the cells in the same row in columns B and C

Any suggestions

Select all of the relevant cells of column A, B, and C.

Activate Format|Conditional Formatting.

Choose Formula Is for Condition 1.

Enter as formula:

=LEN($A1)>0

Activate Format.

Activate the relevant tabs for setting up the desired formatting.

Click OK, OK.

 

[Lewis]

Thanks just fine

 

[Lewis]

Is there any way to prevent the formatting if you enter a formula in the first cell?

 

[Aladin Akyurek]

On 2002-03-02 02:50, Lewis wrote:
Is there any way to prevent the formatting if you enter a formula in the first cell?

How do you mean?

 

[Lewis]

Sorry I was not very explicit. if I put in a formula such as =X1 which will give a zero value if there is nothing in X1,it still gives me the formatting even if I hide the zero

 

[Aladin Akyurek]

On 2002-03-02 03:53, Lewis wrote:
Sorry I was not very explicit. if I put in a formula such as =X1 which will give a zero value if there is nothing in X1,it still gives me the formatting even if I hide the zero

Use

=AND(LEN($A1)>0,$A1<>0)

or, if A is expected to house data of only numeric type,

=$A1<>0

 

[Lewis]

That is great another way I found was to use the original and make it >1 rather than >0 as I am interested in long text strings

 

[Aladin Akyurek]

On 2002-03-02 05:08, Lewis wrote:
That is great another way I found was to use the original and make it >1 rather than >0 as I am interested in long text strings

Lewis,

You must be able to have a number like 4 in A. This number has a LEN of 1!

Aladin