Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Conditional Format - set value in cell if other cell is not blank

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Phoenix, Arizona
    Posts
    525
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional Format - set value in cell if other cell is not blank

    I need to have cell F3 = 0 if cell B3 is blank and no other value has been entered in F3 yet.

    I tried setting the default font color of column F to white and entering 0 in every cell in column F and then using conditional formatting to change the font color to black if a value is entered in column B. That works, but it causes the user to have to change the print range every time because it wants to print the hidden 0's at the bottom of the list where no values have yet been entered into column B.

    Can anyone help me with this format formula?
    Projects that are not worth doing are worth not doing well.

  2. #2
    Board Regular SamTYler's Avatar
    Join Date
    Mar 2004
    Location
    Columbia, Missouri, USA
    Posts
    784
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Format - set value in cell if other cell is not blank

    Code:
    =IF(B3="",0,"")
    Remove all conditional formatting, put that in F3 and copy down column F.

    The formula reads

    IF B3 is blank THEN(comma1) show a zero ELSE(comma2) show nothing
    SamT
    XP+SP3, Office 2003+P2
    Recently of Niland, Ca.
    Now in Columbia, Mo. USA
    No Work, No money, No home

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
  •  


DMCA.com