Ask Experts Questions for FREE Help !
Ask
    cottons's Avatar
    cottons Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Aug 28, 2012, 05:29 PM
    conditional formatting with letters
    I'm studying for the GMAT, and am putting my answers in excel to help me study.

    In my spreadsheet I have 5 columns labeled: first attempt, second attempt, third attempt, -blank-, and correct answer.

    what I want to do is conditional formatting that will highlight the cells if the attempted answer and correct answer do not match. Each column has answers a-e. (this will help me home in on the topics that I struggle with, I hope)

    I wish it was as simple as =if(c2=g2,"",format the damn thing)
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Aug 29, 2012, 09:43 PM
    Conditional formatting formulas are actually much shorter than that. They are are simple TRUE/FALSE constructs.

    So based on your example, if C2 and G2 do not match... the formula would be:

    =C2<>G2

    ... then select your formatting colors.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Conditional Formatting formula is [ 10 Answers ]

I need Conditional Formatting to only highlight dates that exceed 50 years of age. Currently I have =((TODAY()-D4)/365<50). It seems to work on some but not all, any suggestions.

What is letters ? Types of letters ? Types of business letters [ 1 Answers ]

Letters ? Business leaters -types ?how it writes ?

Change font using Conditional formatting [ 1 Answers ]

Dear Sir, I have put two fields in report. I want to change the font (not color) of second textbox according to the data of first field at runtime. I tried conditional formatting, but I could not find changing font. Please help me. Waiting eagerly.

View more questions Search