format cell color

  1. M

    vb script format row color based on cell multiple values

    Hi, I am new to this forum as for posting but I follow up on the posts for a long time. Currently I am working on a spreadsheet where I register deals opportunities, on column I i have a data Validation List of Lost, Won and Invoiced. What I am trying to do is to change the row color to Red...
  2. JARHTMD

    Format based on cell content & color of another cell

    I have an Excel2007 worksheet that I populate by copying and pasting from a website. Those values are transferred into another sheet by formulae... (=QuotesTransition!C3, =QuotesTransition!D3, etc). Negative values in ColC of QuotesTransition are shown in red (0.12 without minus sign). ColD...
  3. C

    If Statement color formatting

    Hi all. I hope you are well. I am trying to work on an If statement and I hope you can help. What I am trying to achieve is this IF Cell O4 = "YES" and C4 <11 and F4 is between 0 and 1 and I4 is between 0 and 1, and L4 is between 0 and 1 then Sum C4, F4, I4 I have attached a picture of my...
  4. M

    VBA - If criteria 'A' is met, AND criteria 'B' is met, format cell accordingly (must use VBA, not conditional formatting)

    I have read several posts regarding conditional formatting based on a criteria but I cannot seem to apply it to my situation -- I have a table of information, I need this to apply to every row of information. Assuming first row of information is '4'.. but needs to check all rows in the table...
  5. S

    Can I have 2 different FILL buttons in the ribbon. One yellow and one blank?

    Running Office 2010, windows 10, 64bit. So really I want a shortcut/hotkey that removes the fill from selected cell/s. I added another fill button to my custom group on the ribbon, but when I change the fill color of the one, it changes the fill color of the other. I want to have a dedicated...

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