+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Excel - count if statement to fill color in a cell in Technical; Hi all Wonder if anyone knew if it was possible to produce a countif statement that would use certain results ...
  1. #1
    rickypike's Avatar
    Join Date
    Sep 2009
    Posts
    93
    Thank Post
    15
    Thanked 16 Times in 16 Posts
    Rep Power
    13

    Excel - count if statement to fill color in a cell

    Hi all

    Wonder if anyone knew if it was possible to produce a countif statement that would use certain results and then fill the cell a certain colour.

    I know you can use a countif to count cell colours.

    I am basically trying to use a countif to pull through assessment data (which I have already done, it works out percentage A-C, A-G etc) and then based on the results then colour the cells that tells me if that grade is expected or beyond expected by comparing it to other data within the spreadsheet.

    Is this possible, any ideas / comments much appreciated. (Office 2010 and 2013 both in use - if that helps)

  2. #2

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    7,015
    Thank Post
    1,362
    Thanked 1,769 Times in 1,191 Posts
    Blog Entries
    22
    Rep Power
    530
    Perhaps I am misunderstanding what you are trying to do, but if you want to colour a cell based on its value, wouldn't using Conditional Formatting on that cell be a better option?

  3. Thanks to sparkeh from:

    rickypike (5th June 2014)

  4. #3
    rickypike's Avatar
    Join Date
    Sep 2009
    Posts
    93
    Thank Post
    15
    Thanked 16 Times in 16 Posts
    Rep Power
    13
    Yes I am already using some conditional formatting within the spreadsheet, I might be over complicating it (perhaps need a coffee and a break) by trying to make one formula do everything. What I think I'm going to do is use a countif to tot up all the grades and then another to put into A-C, A-G and work out the percentages etc (which I have working great and colour coding) and then create a separate column that then does a countif against that data to give me expected or beyond expected progress and then conditional format the results - hope that kinda makes sense. Thanks sparkeh for the info..... it was what I needed..

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 8
    Last Post: 15th November 2010, 10:31 AM
  2. Replies: 12
    Last Post: 2nd June 2010, 09:42 AM
  3. Please find 5 mins to fill this in
    By Dos_Box in forum Site Polls
    Replies: 22
    Last Post: 19th September 2009, 02:56 PM
  4. Tips to fill in applicaton
    By jonayed in forum Educational IT Jobs
    Replies: 12
    Last Post: 15th June 2009, 10:57 PM
  5. Excel IF statement maybe VB
    By danIT in forum General Chat
    Replies: 1
    Last Post: 5th January 2007, 12:12 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •