Select the cells you want to be analyzed and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Highlight Cell Rules” and “Between …” From the new menu choose the amounts between which the cells are formatted and from the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”.
Continue readingTag Archives: format
How to automatically format if the values are lower than specified amount? | Excel 2007
Select the cells you want to be analyzed and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Highlight Cell Rules” and “Less Than …” From the new menu choose the amount from which the cells are formatted and from the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”.
Continue readingHow to have cells automatically formatted if they fall into specific date? | Excel 2007
Select the cells you want to be analyzed and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Highlight Cell Rules” and “A Date Occurring …” From the new menu choose the date from which the cells are formatted and from the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”.
Continue readingHow to copy formatting? | Excel 2013
Click on the cell from which you would like to copy the format. Go to home tab and Clipboard group. Select format painter. Click on the cells to copy the format.
Continue readingHow to automatically format if the values are higher than specified amount? | Excel 2007
Select the cells you want to be analyzed and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Highlight Cell Rules” and “Greater Than …” From the new menu choose the amount from which the cells are formatted and from the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”.
Continue readingHow to have a different page formatting in a single document? | Word 2007
Section breaks are used to show Word where the formatting will end and a new one will start. You will find section breaks on Page Layout tab under Page Setup section. Click on “Breaks” and choose how you want for the section break to work. Does it need to skip to a new page or for an example to a new even-numbered page. After this break you can apply new formatting.
Continue readingHow to have cells automatically formatted if they contain specific text? | Excel 2007
Select the cells you want to be analyzed and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Highlight Cell Rules” and “Text That Contains …” From the new menu type in the text which the cells containing are formatted and from the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”.
Continue reading