Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2015
    Posts
    9
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Conditional Formatting

    I am trying to base conditional formatting based on if a cell is equal to one of 5 cells.

    So in my case the default cell font color is red however if a cell from D8:J17 equals cells K2 K3 L3 M3 M4

    I would like that specific cell in the D8:J17 range font color change to black.

    I tried the conditional formatting however creates an error

    "You may not use reference operators (such as unions, intersections, and ranges) or array constants for Conditional Formatting criteria."

    What would be the best way to ensure this formatting occurs.

    Also I am using Excel 2010
    Last edited by nsmjc1; 2015-10-25 at 18:52. Reason: Solved

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,643
    Thanks
    115
    Thanked 652 Times in 594 Posts
    nsmjc1,

    select D8:J17 and add the following rule:

    =OR(D8=$K$2,D8=$K$3,D8=$L$3,D8=$M$3,D8=$M$4)

    HTH,
    Maud

  3. The Following User Says Thank You to Maudibe For This Useful Post:

    nsmjc1 (2015-10-25)

Posting Permissions

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