Results 1 to 5 of 5

Conditional formatting: One cell based on the value of another

Threaded View

  1. #1
    Registered User
    Join Date
    12-15-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    16

    Conditional formatting: One cell based on the value of another

    Hi all,

    I am attempting to apply conditional formatting such that cell B3 is green if it is greater than or equal to cell B2, and red if less than cell B2. Then to apply this conditioning across the row of data (i.e. C3 >= C2 green, C3 < C2 red; D3 >= D2 green, D3 < D2 red; E3 >= E2 green, E3 < E2 red ... etc.).
    Needs to be formatted such that if I change the value in cell B2, the colour of B3 is automatically updated.


    Please find attached an example worksheet.


    Thank you for your time and assistance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting via VBA: Change formatting in range based on value of each cell
    By ralphjmedia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2013, 10:37 AM
  2. [SOLVED] Conditional formatting based on cell value in row above
    By thadacto in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-14-2013, 04:07 PM
  3. Replies: 4
    Last Post: 01-06-2012, 05:07 PM
  4. Conditional Formatting based on value of last cell
    By Bret in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2008, 12:44 PM
  5. Conditional formatting based on another cell
    By Shaggyjh in forum Excel General
    Replies: 7
    Last Post: 02-10-2006, 12:10 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