conditional format color

  1. E

    Conditional Formatting and Negative Numbers!

    Hi! I have what I think should be very simple, but is not working for me right now! I am working on a scorecard sheet. So, we have a number of metrics, and for each we have Target and Goal for every month. Then, for each metric, there is a calculation of the percentage-where are they in...
    • excellearner18
    • Thread
    • conditional cell colour conditional format color learner negative and positive negative percentages
    • Replies: 4
    • Forum: Excel Questions
  2. H

    conditional format color count

    I'm using excel 2013. How do I count the number of cells that have been conditionally formatted to be a certain color and output the result in another cell? I have a spreadsheet full of stock picks. All stocks are displayed in rows 5-50 Different analysts ratings are displayed in columns F thru...
  3. dbig

    Background Fill portion of Conditional Formats is not working

    The Background Fill portion of Conditional Formats has stopped working. Both the range and the formula are valid because the Bolding of the font and the Underline-ing of the rows work as expected. Only the colored fill is missing. For instance, the CF formula is =AND(MOD(ROW(),3)=0, $A1<>"")...
  4. J

    Conditional Formatting Issue (counting by colour)

    I am using the following website to try and count the coloured cells in workbook (including the code posted): https://www.ablebits.com/office-addins-blog/2013/12/12/count-sort-by-color-excel/ I have conditionally formatted my work, and I can see that it is working (all the cells I want...

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