automatic formatting

  1. L

    Conditional Formatting - VBA Code (Referencing a Cell)

    With the problems and limitations I have had with the "Conditional Formatting" in the Styles Menu I have decided to approach it a different way and need your help.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> The table below is just a small...
  2. CHARLESJOSEPH

    Automatically setting format in columns

    This is another slow pitch over the plate for all you Excel wizards :)... Column B, F, & G - require upper case, Arial 10, and center alignment Columns D & E - require upper case, Arial 8, and center alignment Column H - require lower case, Arial 8, wrapping text, and left alignment...
  3. S

    Mutiple Reporting Sheets

    Hi all, Hoping someone will be able to help. At present i have 10 sheets within 4 workbooks that then collate the values (countif) in to one sheet. The information that is put in these sheets is entered daily and i need to keep a copy of this data in a seperate tab, which i noramally have to...

This Week's Hot Topics

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
Top