Results 1 to 2 of 2

Thread: Conditional Format - 1 Cell to change color
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2008
    Posts
    193
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional Format - 1 Cell to change color

    Hello all,

    How do conditional format A1 to change color if a specific word is somewhere in Column A?

    Greatly appreciate any help

    Bob

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,263
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Conditional Format - 1 Cell to change color

    Select cell A1
    Then, click Home > Conditional Formatting > New Rule.
    In the New Formatting Rule dialog box, click Use a formula to determine which cells to format.
    Under Format values where this formula is true, type the formula:

    Code:
    =COUNTIF($A:$A,"some")>0

    Click Format.
    Select Color.
    Click OK.
    Click OK.

    Change "some" for the word you want
    Regards Dante Amor

Some videos you may like

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
  •