Results 1 to 4 of 4

Conditional formula based on previous columns

Threaded View

  1. #1
    Registered User
    Join Date
    07-30-2020
    Location
    London
    MS-Off Ver
    365
    Posts
    53

    Conditional formula based on previous columns

    This is probably a nice easy one... (three questions/parts)

    Table of numbers.

    1:
    If values in column B = 0, colour green,
    If values in column B > column A, colour red
    If values in column B < column A (but <>0), colour amber

    2:
    How do I copy the above so the same rules apply in respective columns, i.e. B compared to A, C compared to B, D compared to C... I tried format painter with no luck (am I doing it wrong?)

    3:
    How do I colour scale the above formulae?
    i.e.:
    If column B is 0, colour green,
    If values in column B ≥ column A, colour amber to red based on the previous values in that row
    If values in column B ≤ column A, colour amber to green based on the previous values in that row

    ...and likewise copy to other cells
    Attached Files Attached Files
    Last edited by beternal; 06-28-2021 at 10:55 AM. Reason: attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to sum every 2 columns based on criteria found in previous column
    By PaulM100 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-02-2018, 05:08 AM
  2. Conditional Formatting Formula Based on Text in Previous Cell
    By koricw in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2018, 09:02 AM
  3. Conditional Formatting based on previous worksheet
    By jedbanger2 in forum Excel General
    Replies: 2
    Last Post: 08-07-2017, 03:32 PM
  4. [SOLVED] Indirect Formula to report content based on two previous columns?
    By Amigo1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2014, 08:18 AM
  5. Correct formula for adding columns based on previous row
    By packers316 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-02-2013, 06:44 AM
  6. [SOLVED] Conditional Formula based upon multiple columns
    By KsuGuy26 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-03-2013, 01:13 PM
  7. [SOLVED] Conditional Formatting Formula based on the previous "Last" Monday.
    By avidcat in forum Excel General
    Replies: 3
    Last Post: 09-17-2012, 03:47 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