Conditional Formatting if last two digits are not equal to
Attend Excelapalooza
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
    249
    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,331
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 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
    249
    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

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
  •  

 

 
DMCA.com