cell color fill

  1. A

    VBA to replace cell value to zero for columns having Header Date

    Hello Excel/VBA People, I am looking for a vba code that will replace the value of a cell (with yellow color) to zero for those columns having Dates as the Header column only. Example: In a certain excel file there are tabs/sheets that contain the column names Supplier name, Amount, and dates...
  2. D

    How to make cells in one column change fill colors base off of two conditions

    Hello, I am looking to have a column of dates (column G) fill GREEN based off the conditions: 1. If there is a "P" (stands for portables) in column F 2. If the date listed in column G is over one year old (365 days+) I am also looking to have the same column of dates (column G) turn GREEN...
    • dstimpson
    • Thread
    • cell color fill colors dates two column conditions two conditions
    • Replies: 2
    • Forum: Excel Questions
  3. C

    Coloring cells based on a date range

    Hey all, I asked a question similar to this the other day, but have changed my approach and wanted to get some input. Based on the date ranges in the table below, is it possible to use conditional formatting, or VBA, to color cells a solid color. Even better, if possible, can I use a gradient...
    • crtk09
    • Thread
    • cell color cell color fill color fill conditional formatting gradient fill project timeline timeline
    • Replies: 2
    • Forum: Excel Questions
  4. I

    Excel Error

    hi, i've been with several errors and excel strange behavior: .color fill is not as the choosen.(ex. i choose yellow and it show magenta or try blue and the cell it shows green, etc.) .crashes alot, special when try to print. do not happens on word or other apps. any idea? tnks in advced...

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