+ Reply to Thread
Results 1 to 3 of 3

formatting highlights last number

  1. #1
    Forum Contributor
    Join Date
    10-31-2018
    Location
    venezia
    MS-Off Ver
    2007
    Posts
    487

    formatting highlights last number

    I to all.
    This formula in formatting

    =AND(D9<>"",SUM(D9:$D$361)=D9)

    highlight the last number.
    If the last number is zero it is highlighted twice.
    it is possible to change because if zero is highlighted only this?
    thanks you
    john
    Attached Files Attached Files

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: formatting highlights last number

    You could try changing the conditional formula to:

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Forum Contributor
    Join Date
    10-31-2018
    Location
    venezia
    MS-Off Ver
    2007
    Posts
    487

    Re: formatting highlights last number

    Thanks you, WBD
    A greting.
    john

+ 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. [SOLVED] Dynamic conditional formatting highlights from dropdown
    By chaiyya345 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2020, 05:59 AM
  2. Replies: 3
    Last Post: 10-30-2018, 11:11 AM
  3. Conditional Formatting with 2 Highlights (IF condition)
    By kobokan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-06-2017, 12:59 AM
  4. [SOLVED] Conditional formatting: Cell highlights after a given date
    By peoplemover in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2013, 06:49 PM
  5. Replies: 6
    Last Post: 05-31-2013, 04:49 AM
  6. Conditional Formatting Value highlights multiple values
    By brent_bris in forum Excel General
    Replies: 15
    Last Post: 04-22-2013, 11:26 AM
  7. Conditional Formatting Help-highlights a single row
    By Tommy1005 in forum Excel General
    Replies: 1
    Last Post: 02-22-2011, 02:22 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