+ Reply to Thread
Results 1 to 7 of 7

Conditionally Format Formula for cells containing numbers

Hybrid View

  1. #1
    Registered User
    Join Date
    10-12-2011
    Location
    Police State of DC
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Conditionally Format Formula for cells containing numbers

    Sure, apologies for the lack of clarity. The gist is that a spreasheet is being populated by conditionally bringing in data from a root worksheet if formulas are met.

    - In the row where the formula is met, columns A thru I will be populated with data (columns A and B being numbers and C thru I are text data).
    - In the rows where the formula is not met, columns A thru I are populated "" placeholders.

    My goal is to border the cells of only those rows in which the formula is met. Ex:

    ..................A.....................B......................C......................D
    Row1:....123456............1......................data...............data
    Row 2: .....""....................."".......................""....................""
    Row 3:...123456............1......................data...............data

    I would want the cells of Rows 1 and 3 outlined and row 2 ignored and tried using a formula to validate the first column of each row as containing 6-digits: Thus return of 6-digitis equals success and outlining, whilst return of "" (or NOT 6 digits equals fail and no outlining)
    Last edited by slipleft; 10-12-2011 at 03:35 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1