+ Reply to Thread
Results 1 to 1 of 1

Prevent entry in cell based on color format of another cell and based on specific value

  1. #1
    Registered User
    Join Date
    12-20-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    7

    Prevent entry in cell based on color format of another cell and based on specific value

    I consider myself a notice at Excel and learn daily through trial and error.

    I’m looking for assistance with a spreadsheet (see attached) where I have applied conditional formatting in Column D that defaults to grey color but changes to white whenever a selection is made or data are entered in the preceding cell. This alerts the user that when the cell turns white, they should enter data and when the cell is grey that they should not answer the question. For example, when question 1 (E3) is answered question 2 (E4) changes from grey to white. Ideally, the user would answer questions in sequential order.

    1) I would like to apply a rule that prevents the user to enter data whenever a cell is grey but allows an entry if the cell is white.
    2) For Question 9 (E11) when the user enters “99.99” in the cell I want to apply conditional formatting that does not change the cell from grey to white. Right now, I have a simple formula applied that if E10 is not null then it turns white. But evidently, I need a more specific formula that permits the entry of appropriate values.
    3) I have a similar request for Question 10 (E12) but this cell value is slightly different = “999.99”

    Any help is appreciated.

    Marie
    Attached Files Attached Files

+ 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. VBA Set Color Text Variable based on color entry in a cell?
    By learning new things in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2018, 11:18 AM
  2. [SOLVED] format color into range of cells based on specific cell input
    By Juli in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-01-2018, 10:18 AM
  3. Change cell format (cell color+font color) based on color of another cell
    By Dedaluss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2017, 03:27 AM
  4. Color Cell Based on Specific Text in Other Cell and Sorting Based on Results
    By kre30a in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2016, 07:51 PM
  5. Delete row based on cell FORMAT (color, font, etc) (not based on cell value)
    By trobey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2012, 10:39 AM
  6. [SOLVED] Row Color based on cell entry
    By briank in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-21-2006, 01:25 PM
  7. Prevent entry based on another cell value
    By Melissa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2005, 12:06 PM

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