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

**Will Tank** · 11-23-2020, 11:24 AM

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

**alansidman** · 11-23-2020, 11:26 AM

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

**Will Tank** · 11-23-2020, 11:33 AM

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

**rorya** · 11-23-2020, 11:54 AM

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.

**Will Tank** · 11-23-2020, 12:04 PM

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?

**rorya** · 11-23-2020, 12:15 PM

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.

**Will Tank** · 11-23-2020, 12:15 PM

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

**rorya** · 11-23-2020, 12:16 PM

Glad to help.

**alansidman** · 11-23-2020, 01:35 PM

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.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Need to bold entire row and color green at first blank cell in column

[SOLVED] IF Cell is blank, calculate, if cell isn't blank, leave blank

Calculate differnce between 2 dates, but if 1 date cell is blank leave cell blank

[SOLVED] Concatenate If Blank - remove blank line if first cell is blank

reference cell should be blank not 00-jan-00 how make it read like the blank cell (Blank )

[SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell

If cell blank OR another cell blank then show blank, if not display value

Bookmarks

Bookmarks

Posting Permissions