Results 1 to 6 of 6
  1. #1
    x2dull4u is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2021
    Posts
    12

    Conditional Formatting to determine if a number in a field is even

    Trying to figure out the Syntax. In Conditional Formatting to determine if a number in a field is even. Tried "Mod 2=0" made sure I have square brackets around field name Etc...I cant figure this out. Thank you for any advise, anyone could give me.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    [ID] Mod 2=0 works for me? also without [] if no space in fieldname?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    x2dull4u is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2021
    Posts
    12
    I keep getting invalid syntax. would you please show me how you would right the syntax in the "Expression is"

  4. #4
    x2dull4u is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2021
    Posts
    12
    Sorry, disregard I just figured it out....Also for the cross posting I waited 10 hours with no responses so I posted here. I didn't know I was to attach a link to that other post. Thank you and Again sorry

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    Quote Originally Posted by x2dull4u View Post
    Sorry, disregard I just figured it out....Also for the cross posting I waited 10 hours with no responses so I posted here. I didn't know I was to attach a link to that other post. Thank you and Again sorry
    Well, please advise that other site that issue is solved. Might also want to mark this solved here, using Thread Tools, top right of post?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #6
    x2dull4u is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2021
    Posts
    12
    as to the "issue is solved" I just did it thanks for that, First time here still on the learning curve...lol, Thanks for all your help

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 20
    Last Post: 09-08-2020, 10:40 AM
  2. Replies: 5
    Last Post: 03-20-2018, 06:52 PM
  3. Replies: 1
    Last Post: 01-05-2017, 05:14 PM
  4. Replies: 3
    Last Post: 12-24-2015, 02:48 PM
  5. Conditional number formatting
    By numberguy in forum Reports
    Replies: 6
    Last Post: 06-19-2014, 02:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums