+ Reply to Thread
Results 1 to 4 of 4

Need formula to highlight rows

  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Need formula to highlight rows

    Hello - I am not sure if this can be done in an IF statement.

    I have an IF statement here =IF(A2=A3, "Yes","No") which checks the value in column A if the value following is the same as the value prior it returns "Yes" otherwise, it returns "No". I need this statement to also be able to highlight the entire row where "Yes" is returned. Can this be done in the same IF statement? or should I add a new column for a new IF looking at just the "Yes"? How can this be written?

    Thank you!!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,055

    Re: Need formula to highlight rows

    Just select row and write in CF:

    =$A2=$A3
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    05-14-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Need formula to highlight rows

    hi Zbor- thanks but I am not sure if I understand you...select which row? I know that your formula gives me the True/False value, but it doesnt hightlight the entire row where True (Yes) shows in a color...
    Will you clarify please? Thanks!

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,055

    Re: Need formula to highlight rows

    Select row
    Go to conditional formatting and write this criteria and format row as you like

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 11-12-2013, 04:56 PM
  2. Replies: 5
    Last Post: 11-08-2013, 05:57 AM
  3. Highlight rows.
    By vtxvtx in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-18-2012, 11:46 AM
  4. Replies: 2
    Last Post: 06-27-2012, 12:27 PM
  5. [SOLVED] highlight/remove highlight of rows conditional on cellvalue
    By timtim89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2012, 07:14 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1