Conditional Format not working
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Conditional Format not working

  1. #1
    Guest

    Default

     
    I am trying to change the color of the texts in a column with text "Grade or Code"
    I am in the Conditional Format->Formula Is.
    Then I type in
    =OR("Grade","Code")
    however, it doesn't work
    Did I do something wrong?
    Please help
    Thanks in advance

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,748
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    On 2002-03-14 10:13, Anonymous wrote:
    I am trying to change the color of the texts in a column with text "Grade or Code"
    I am in the Conditional Format->Formula Is.
    Then I type in
    =OR("Grade","Code")
    however, it doesn't work
    Did I do something wrong?
    Please help
    Thanks in advance
    =OR(A1="Grade",A1="Code")

    where A1 is the cell to which you want to apply cond format.

User Tag List

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
  •  

 

 
DMCA.com