Results 1 to 2 of 2

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

This is a discussion on Conditional Format - set value in cell if other cell is not blank within the Excel Questions forums, part of the Question Forums category; I need to have cell F3 = 0 if cell B3 is blank and no other value has been entered ...

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Phoenix, Arizona
    Posts
    490

    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

    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

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