Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Conditional Formatting (XL97)

    Does anyone know how to apply Conditional formatting to a cell (or range of Cells), based on the value of another cell.

    Eg, apply [BOLD] to A2:A15 if len(A1)=5

    Thanx in Advance for any advice

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (XL97)

    1- Select the cell or cells that are to be conditionally formatted.

    2- Select Conditional Formatting from the Format menu.

    3- From the dropdown list in the dialog box select "Formula is."

    4- In the Text Box enter =LEN(A1)=5

    5- Click the Format... button.

    6- On the Font tab click on Bold, then click OK.

    7- Clcik the OK button.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (XL97)

    Beudy! That works great, thanx a bunch

  4. #4
    New Lounger
    Join Date
    Jan 2002
    Location
    Black Earth, Wisconsin, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (XL97)

    I have been trying to figure out conditional formatting on one of my spreadsheets. I have searched the lounge and read everything in Help. I still can't get it to do what I need. I know it is probably very easy but I'm not that proficient in formulas. Any help is appreciated.
    The spreadsheet has two columns (H and J) I am trying to compare row by row (H1 compare to J1). When the numbers are equal nothing is changed. If the numbers are not equal I would like them to format to BOLD and grey coloring. I can get one row to do what I want using "The cell value" " is not equal". But I can't copy the formula so it will work on all 200 rows of information. Do I need to use "the fomula is" instead of "cell value"? If so what type of formula do I enter? I have attached the workbook.

  5. #5
    New Lounger
    Join Date
    Jan 2002
    Location
    Black Earth, Wisconsin, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (XL97)

    My attachment was too large so I am posting again. Sorry.
    Attached Files Attached Files

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (XL97)

    Try the following:

    1- Select all of the cells to be conditionally formatted, with the top left cell active.

    2- Go to the Conditional Formatting dialog.

    3- In the drop down list select "Formula is".

    4- In the formula text box enter: =$H1<>$J1

    5- Click the Format button and select the formating you want when the cells are not equal.

    6- Click OK.

    7- Click OK.
    Legare Coleman

  7. #7
    New Lounger
    Join Date
    Jan 2002
    Location
    Black Earth, Wisconsin, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (XL97)

    Thanks a bunch. It worked. This will save me loads of time in the future.
    Your advise is always right on. Thanks again.

Posting Permissions

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