Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Conditional formatting

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks just fine

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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?

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  8. #8
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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



  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  10. #10
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •