+ Reply to Thread
Results 1 to 2 of 2

Conditional Format Based on the Cells Used in Formula

  1. #1
    Registered User
    Join Date
    12-02-2013
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Conditional Format Based on the Cells Used in Formula

    On sheet1 (used for data entry) I have a spreadsheet of dimensions. These dimensions are taken as the high and low (i.e. 13.250 in cell A1, 13.245 in cell A2). On sheet2 (used for clearance calculations) I have cell A1 to take the average between cells A1 and A2 from the first page. What I would like to do is conditionally format the cell showing the average to turn red if the difference between A1 and A2 is greater than .003. My spreadsheet is NOT setup in very straightforward columns/rows. There is no merged cells being dealt with, but this is a document going to a customer so appearance and functionality are both important. I will have to do this for about 100 cells and would not prefer to individually format them based on what is found in sheet1. Can I in anyway reference the cells used in the formula to conditionally format? Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Conditional Format Based on the Cells Used in Formula

    Please attach a sample of your workbook so we don't need to re-create your work to find possible solutions. Remember to remove/replace sensitive info before uploading the file.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ 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. How to conditional format cells based on vlookup/match formula
    By dougebowl in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-21-2013, 06:50 PM
  2. Replies: 2
    Last Post: 09-26-2012, 04:43 AM
  3. Replies: 3
    Last Post: 09-13-2012, 03:25 AM
  4. Conditional format formula based on two cells
    By sandernoteborn in forum Excel General
    Replies: 8
    Last Post: 04-09-2009, 05:40 AM
  5. [SOLVED] Conditional format based on other cells
    By Tonto in forum Excel General
    Replies: 1
    Last Post: 07-07-2006, 01:15 PM

Tags for this Thread

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