+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Red or Green Cells and Sum the amount in a "total cell"

  1. #1
    Registered User
    Join Date
    10-04-2017
    Location
    Darlington
    MS-Off Ver
    2013
    Posts
    2

    Post Conditional Formatting Red or Green Cells and Sum the amount in a "total cell"

    Hi,

    I need help figuring out a formula that will change the colour of a cell to red if a letter "I" is entered, or green if a letter "A" is entered. I also need the formula to calculate the total number of "A"s that have been entered for a particular row and the total number of "I"s for a particular row. I've attached an image which may help. Conditional formatting.PNG

    Thank you in advance!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,207

    Re: Conditional Formatting Red or Green Cells and Sum the amount in a "total cell"

    for CF

    select first cell in range e.g, B2

    =B2="A"

    set colour to Green

    Set "Applies to" to your required range e.g B2:Z100

    Same for I

    to count

    =COUNTIF(Range,"A")

+ 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: 5
    Last Post: 03-07-2017, 05:23 PM
  2. copy "green fill with dark green text"
    By stephme55 in forum Excel General
    Replies: 1
    Last Post: 02-04-2017, 02:04 AM
  3. Formula help =countif(A2:A229, "europe",B2:B229,"Green")
    By aledrob in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-24-2016, 11:09 AM
  4. Return "green", "yellow" or "red" from date/age and priority ranking
    By Cantaloop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2013, 12:12 AM
  5. [SOLVED] Conditional formatting - formula if cell does NOT contain "," or "@"
    By Armitage2k in forum Excel General
    Replies: 12
    Last Post: 12-02-2012, 06:23 AM
  6. Replies: 2
    Last Post: 08-17-2012, 05:10 AM
  7. [SOLVED] Macro to delete entire row if cell contains the word "total" or "Total"
    By theatricalveggie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2011, 12:38 PM

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