+ Reply to Thread
Results 1 to 2 of 2

Conditional Format

  1. 04-11-2014, 06:57 AM #1
    pdizzy
    pdizzy is offline
    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
    Reply With QuoteRegister To Reply
  2. 04-11-2014, 07:43 AM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need conditional format to check prior sheet for a given number and change format if found
    By Bearded Dan in forum Excel General
    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. [SOLVED] Is it possible to format cells based on their value? (Not a conditional format query)
    By The_Snook in forum Excel General
    Replies: 2
    Last Post: 09-26-2012, 04:43 AM
  4. Excel 2007 : Conditional Format based on another worksheet conditional format
    By zipper_018 in forum Excel General
    Replies: 0
    Last Post: 05-20-2011, 02:33 PM
  5. [SOLVED] format cells yyyymmdd and then conditional format
    By joesport5 in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1