Results 1 to 3 of 3

Conditional Formatting Error

Threaded View

  1. #1
    Forum Contributor Big.Moe's Avatar
    Join Date
    03-15-2012
    Location
    Corea, Maine, USA
    MS-Off Ver
    Excel 2010
    Posts
    258

    Conditional Formatting Error

    Hello,

    I created a conditional formatting rule that compares the mileage derived from the odometer data on the left of the spreadsheet (column J) to the total state miles entered in the right side of the spreadsheet (column AF) and highlights the cell on the right when it does not match the cell on the left (see image below). This has been working just fine for a couple years. However, lately the highlighting rule has started to highlight the cell even though it does match the cell on the left (it's supposed to only highlight when the two cells don't match). The only change that has happened is that we started entering the mileage in tenths of a mile instead of whole miles previously. The cell number formats have always been formatted with one decimal point, but we previously only entered whole miles.

    I don't know why this should affect the highlighting rule, but that has been the only change. I have checked and double checked everything else, but I cannot figure out why this is occurring. Any thoughts or suggestions would be greatly appreciated. I have attached a small sample file for your use (the affected cells are AF197 & AF204 on the "#41" tab).

    Thank you.

    Highlight Problem.jpg
    Attached Files Attached Files
    Last edited by Big.Moe; 07-13-2022 at 10:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting - Run Time Error '13' Type Mismatch Error
    By ksp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2011, 07:37 PM
  2. Conditional Formatting Error
    By jamaljan in forum Excel General
    Replies: 4
    Last Post: 04-11-2010, 09:11 PM
  3. conditional formatting for Error
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM
  4. [SOLVED] conditional formatting for Error
    By krupesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  5. conditional formatting for Error
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 02:05 PM
  6. conditional formatting for Error
    By krupesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  7. conditional formatting for Error
    By krupesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  8. [SOLVED] conditional formatting for Error
    By krupesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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