conditional color case

  1. G

    How do I count conditional formatted cells based on it's colors.

    Good day everyone and professionals in the house Please I really need your help with this, I have been trying to count conditional formatted cells based on it's colors, but when I didn't find the appropriate code I had to start filling it up manually. So there are 3 major colors there Green...
    • Goldenrules
    • Thread
    • conditional cell colour conditional color case conditional color count
    • Replies: 3
    • Forum: Excel Questions
  2. B

    Conditional formatting/coloring depending on values of 2 different cells

    Hello I have spent my whole 2 full days trying to solve this one and i was no able therefore i am asking please for your help. I have a simple table that includes 3 Tactics : A, B and C. Each Tactic is defined by 2 numerical parameters (Parameter 1 and Parameter 2) which are set and fixed in...
  3. J

    Conditional Formating.

    I have Column E with a date and time stamp example- Mon Sep 01 12:13:52 EDT 2014. I want to be able to identify via highlighting or use the true statment if times in Column E are between 17:00 and 19:00. There are 396 rows I have with diffrent Date and Time Stamps in Column E. What is the...
    • jschoon4
    • Thread
    • conditional color case conditional formatting formatting
    • Replies: 1
    • Forum: Excel Questions
  4. H

    Help Needed: Colouring Rows the same where they match (using alternating colours)

    Hi All, Following on from your help in previous threads, I've got a merged spreadsheet! Hooray! :cool: Now I have a (very long) spreadsheet filtered by name. So for example Location----------UserID------First Name--------Surname Manchester--------12345--------Bob--------------Smith...
  5. T

    Question on Cell Color Based On Input

    Hello, I am an Excel newbie and have exhausted what detail I could find on the web to help me debug this problem. The code below works if you type the word 'ID' or 'Severity' in a cell, it changes to Purple with a yellow-ish font. It only works if you paste in the word 'ID' or 'Severity'...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top