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 17:52. Reason: Solved

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,980
    Thanks
    157
    Thanked 773 Times in 705 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
  •