Results 1 to 4 of 4

Thread: Conditional formatting problem

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,327

    Conditional formatting problem

    I'd like to have a conditional formatting rule apply to cells with any of these values 10, 20, 30, 40, 50, 60, 70 or 80. I know that if there was just one value (for example 10) that I could use =C3:V8=10. I also know that I could create 7 other similar rules for 20, 30, etc, but how can I do it with just one rule?

  2. #2
    Frenzied Member
    Join Date
    Nov 2017
    Posts
    2,029

    Re: Conditional formatting problem

    This should work.

    Code:
    =IF(AND(AND(V8 >= 10, V8 <= 80), MOD(V8,10) = 0), C3,0)
    Last edited by OptionBase1; May 24th, 2022 at 03:32 PM.

  3. #3

  4. #4
    Frenzied Member
    Join Date
    Nov 2017
    Posts
    2,029

    Re: Conditional formatting problem

    Ok. Untested.

    Code:
    =IF(OR(V8=10, OR(V8=20, OR(V8=30, OR(V8=40, OR(...)))))))), C3, 0)

Posting Permissions

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



Click Here to Expand Forum to Full Width