+ Reply to Thread
Results 1 to 2 of 2

Conditional Format

  1. #1
    Registered User
    Join Date
    12-09-2006
    Posts
    26

    Conditional Format

    Hi

    I need a way to format the color of a cell based on the value of the cell above it. For example if A4=5 A5=6 A6=6 A7=3 then I want cells A5 and A6 to be highlighted. This only needs to be highlighted if adjacent cells are of the same value. Can this be done?

    THX in advance

    PD

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Conditional Format

    Make a new rule for conditional formatting. Select the range A5 to say A50, while A5 is active cell, try this formula for conditional formatting......

    Please Login or Register  to view this content.
    and set the format as per your requirement.

    For detail see the attached sheet.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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: 3
    Last Post: 05-15-2013, 12:16 AM
  2. [SOLVED] Copy Conditional Format only without over writing existing format
    By RobNorwichUK in forum Excel General
    Replies: 2
    Last Post: 01-22-2013, 12:20 PM
  3. Replies: 2
    Last Post: 09-26-2012, 04:43 AM
  4. Replies: 0
    Last Post: 05-20-2011, 02:33 PM
  5. Replies: 6
    Last Post: 08-02-2010, 04:05 PM

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