+ Reply to Thread
Results 1 to 8 of 8

Conditional formating multiple cells based on blank or filled single cell.

  1. #1
    Registered User
    Join Date
    12-15-2006
    Posts
    4

    Conditional formating multiple cells based on blank or filled single cell.

    Im trying to put a line at the top of a row of cells if the first cell is NOT empty

    Basically if A1 has a value then A1:U1 are to have an above line. If A1 is blank then there is no formating.

    Ive tried using "formula" option in conditional formating with =A1>0 but that is not working and doesnt shift the cell refecence down when coppied to multiple rows, it still references A1 instead of say A2.
    Last edited by turbotank; 12-13-2012 at 10:02 AM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Conditional formating multiple cells based on blank or filled single cell.

    Does this helps you?

    =$a1>0
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    12-15-2006
    Posts
    4

    Re: Conditional formating multiple cells based on blank or filled single cell.

    Thats exactly how I want it to work and the exact formula I used but its over lining every cell even if the reference cell is empty...

  4. #4
    Registered User
    Join Date
    12-15-2006
    Posts
    4

    Re: Conditional formating multiple cells based on blank or filled single cell.

    I think I figured out why its still over lining cells that are empty... The cell that is blank references another cell with an If statment that returns "" or a value based on conditions. I added a column in the spreadsheet to return a 0 or a 1 if A1 is "" and used that for the true formula in the conditional formating. Basically is =W1=1 then it gets an overline... its an *** backwards way but I dont see how to get jsut a true statment to work?

  5. #5
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Conditional formating multiple cells based on blank or filled single cell.

    You mean that in my sample sheet you see red line above of eatch row?

    I see ONLY these rows>>> 3-8-12 &17 to have a red line above them as only in these rows exist something in column A!

  6. #6
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Conditional formating multiple cells based on blank or filled single cell.

    Now i saw your post#4

    You can MODIFY the formula like this, if you do't want to have an extra column.

    =$A1<>""

  7. #7
    Registered User
    Join Date
    12-15-2006
    Posts
    4

    Re: Conditional formating multiple cells based on blank or filled single cell.

    Quote Originally Posted by Fotis1991 View Post
    Now i saw your post#4

    You can MODIFY the formula like this, if you do't want to have an extra column.

    =$A1<>""
    Great! thanks for the help! I think that will work.

  8. #8
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Conditional formating multiple cells based on blank or filled single cell.

    You are welcome!

    Thanks for the reb*

+ 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