Results 1 to 4 of 4

Conditional Formatting for 1st column based on a positive or negative value in 2nd column

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2024
    Location
    Lisburn, Northern Ireland
    MS-Off Ver
    2401
    Posts
    2

    Conditional Formatting for 1st column based on a positive or negative value in 2nd column

    Hi there,

    I have a list of keywords in one column and their changes in rankings in another - positive value for increase in rank (1) and negative value for loss in rank (-1).

    I would like a formula which will highlight the keyword in either green for an increase or red for a loss.

    There is most likely a simple solution but I'm relatively new to formula building within CF.

    Any help is appreciated!

    Thanks,

    Andrew
    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 - Positive/Negative Values
    By jamie1985 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-06-2024, 12:15 AM
  2. [SOLVED] How to sort the data in column B into positive and negative numbers according to column A
    By metrostar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-20-2022, 09:17 AM
  3. Replies: 11
    Last Post: 03-31-2016, 06:26 AM
  4. Replies: 2
    Last Post: 08-04-2014, 08:57 AM
  5. Replies: 6
    Last Post: 05-31-2013, 04:49 AM
  6. Conditional formatting for positive/negative numbers
    By amartino44 in forum Excel General
    Replies: 5
    Last Post: 04-24-2013, 07:17 PM
  7. Replies: 4
    Last Post: 07-08-2010, 09:33 AM

Tags for this Thread

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