Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Conditional Formatting if last two digits are not equal to

  1. #1
    Board Regular
    Join Date
    Apr 2008
    Location
    Oregon
    Posts
    253
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional Formatting if last two digits are not equal to

    I have some payroll hours that need to end in quarter numbers (.25, .50, .75, .00). Is there a way to highlight hours that DON'T end in these four values? Conditional formatting? I know how conditional formatting works but I am unsure how to write this in a formula. Any help would be really appreciated.

  2. #2
    Board Regular
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    5,984
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Conditional Formatting if last two digits are not equal to

    Something like:

    =FLOOR(A1,0.25)<>A1

  3. #3
    Board Regular
    Join Date
    Apr 2008
    Location
    Oregon
    Posts
    253
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting if last two digits are not equal to

    PERFECT!! Never used FLOOR before, that's a new one.....appreciate your help and prompt reply

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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