+ Reply to Thread
Results 1 to 9 of 9

When cell is blank it must be red, when not blank must be green

  1. #1
    Registered User
    Join Date
    11-23-2020
    Location
    Bristol, England
    MS-Off Ver
    Office 365
    Posts
    7

    When cell is blank it must be red, when not blank must be green

    Hello,

    I am trying to make a questionnaire of sorts, i would like all the cells requiring information to be red until they are filled with the information either typed of selected from a drop down then i would like them to turn green.

    thanks

    Will

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    18,989

    Re: When cell is blank it must be red, when not blank must be green

    Please read the yellow banner at the top of this page on how to attach a file.

  3. #3
    Registered User
    Join Date
    11-23-2020
    Location
    Bristol, England
    MS-Off Ver
    Office 365
    Posts
    7

    Re: When cell is blank it must be red, when not blank must be green

    Hi Alansidman,

    Is that still required when the information on the sheet is irrelevant to the code required? As in if black it goes red but if anything is put in either letter or number it goes green.

    thanks

    Will

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    5,216

    Re: When cell is blank it must be red, when not blank must be green

    Format them with red fill, then use conditional formatting using Cell Value, not equal to, and enter ="" in the value box, and apply green fill.
    Rory
    I drink, and I know things

  5. #5
    Registered User
    Join Date
    11-23-2020
    Location
    Bristol, England
    MS-Off Ver
    Office 365
    Posts
    7

    Re: When cell is blank it must be red, when not blank must be green

    Thanks for your help, i have followed that which has made the cells red when empty but how do i now make them green when something is inputted to them?

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    5,216

    Re: When cell is blank it must be red, when not blank must be green

    Select the relevant cells, click Conditional Formatting on the Home tab, then New rule. Choose 'Format only cells that contain' from the Rule types, then choose:
    Cell value, Not equal to, =""
    in the three boxes, click the Format button to pick a green fill, then OK.

  7. #7
    Registered User
    Join Date
    11-23-2020
    Location
    Bristol, England
    MS-Off Ver
    Office 365
    Posts
    7

    Re: When cell is blank it must be red, when not blank must be green

    I am sorry i was reading your reply all wrong. perfect thank you massive help

  8. #8
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    5,216

    Re: When cell is blank it must be red, when not blank must be green

    Glad to help.

  9. #9
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    18,989

    Re: When cell is blank it must be red, when not blank must be green

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 11-02-2017, 12:51 PM
  2. [SOLVED] IF Cell is blank, calculate, if cell isn't blank, leave blank
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2015, 03:54 PM
  3. Calculate differnce between 2 dates, but if 1 date cell is blank leave cell blank
    By Vicious00013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2014, 11:31 PM
  4. [SOLVED] Concatenate If Blank - remove blank line if first cell is blank
    By ker9 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2014, 02:14 PM
  5. Replies: 3
    Last Post: 01-23-2014, 12:19 PM
  6. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  7. If cell blank OR another cell blank then show blank, if not display value
    By stevop622 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-09-2013, 04:07 AM

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