Results 1 to 14 of 14

Conditional Formating or List required to highlight values not pulled through that should

Threaded View

  1. #1
    Registered User
    Join Date
    09-20-2018
    Location
    Bradford
    MS-Off Ver
    2010
    Posts
    15

    Conditional Formating or List required to highlight values not pulled through that should

    Thanks to some lovely people last time we got the 0, and 1 working correctly (well sort of)
    But we've noticed particularly for the V7 and X8 rates that even though there might be a figure i.e 1 or 3 in the Input Template, the value isn't showing up in the Cost Calculation tab.
    Is there a way to highlight these on both/either sheet so we can review them, or possibly change the fomula to make sure it's pulling through correctly as we may be missing loads of revenue we could be collecting?
    I've pulled through the values into Columns AC and AD to demonstrate the costs aren't pulling through as the example but I'd need to apply this to all the columns on the page but if we can fix these two as a priority I'd be grateful!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help required in conditional formating
    By balu2021 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-06-2017, 04:05 AM
  2. Conditional formating based of list of values that grows
    By horsefish01 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2016, 05:21 PM
  3. [SOLVED] Simple Conditional Formating Help Required - If Blank then Red Bold text required
    By thilag in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2014, 12:23 PM
  4. [SOLVED] Multiple Conditional formating required
    By WimpieOosthuizen in forum Excel General
    Replies: 4
    Last Post: 02-06-2014, 07:21 AM
  5. [SOLVED] Fx to highlight multiple values from a list using conditional Formatting
    By HooligaD in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-08-2013, 03:03 PM
  6. Avg values for multiple cells pulled from named list...?
    By rtilghman in forum Excel General
    Replies: 3
    Last Post: 02-03-2010, 11:43 AM
  7. list two columnar values based on conditional formating (text color)
    By beechum1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-12-2006, 05:53 AM

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