Results 1 to 4 of 4

Thread: identify a cell if data missing from another

  1. #1
    Seeker Jannis's Avatar
    Join Date
    May 2020
    Posts
    5
    Articles
    0
    Excel Version
    2016

    Post identify a cell if data missing from another



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    Hope this makes sense, Im trying to make it easier for everyone here by making it visually easy to see if a cell that is part of a calculation is missed

    in a spreadsheet, I have cell A,1 ( product name) this is from a drop down box
    B,1 (total client has ordered) is entered by sales rep
    C,1 ( pack size) entered by sales rep
    G,1 ( total value of order) automatic formula in this cell

    What I would like to happen is if the sales rep enders a value in A,1 and misses entering info into either B,1 or C,1 then G,1 will end up having a background colour to signal that data is missing

    Can anyone please tell me if this is possible and or how to achieve this

    Thanks in advance for any help

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,716
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi
    try a condtional formatting of cell G1 ( or the range starting in G1) with a condition like =AND(A1<>"",OR(b1="",C1="")) and format as required
    Thank you Ken for this secure forum.

  3. #3
    Seeker Jannis's Avatar
    Join Date
    May 2020
    Posts
    5
    Articles
    0
    Excel Version
    2016
    Works perfectly, thank you very much

  4. #4
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,716
    Articles
    0
    Excel Version
    2010 on Xubuntu
    You're welcome
    Thank you Ken for this secure forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •