Conditional Formatting in Excel

This is when you have a set of figures and you would like to have Ms Excel to auto format them with given conditions.

 

Step 1. Highlight the set of figures, Go to File à Format à Conditional Formatting

Step 2 Define the conditions you want, eg. For figures more than 300, I would like to have it colored.

Step 3 Follow through the steps in the pictures shown and you will get the conditional format you want

 

You can add more than one condition too when you do the conditional formatting in Ms Excel.

How to retrieve "Monday, Tuesday, Wednesday, etc" from a given date in Ms EXCEL?

1. definition: - [$-F800]dddd, mmmm dd, yyyy

2. Eg - Friday, April 01, 2011

3. Therefore, dddd represent the ‘Friday’ , while ddd will represent ‘Fri’

Step 1. highlight the cell containing the date you want to have it formatted

Step 2 Right click on the cell and Format Cells à Date à Choose the one with “Wednesday…. March dd yyyy”, Press OK

Step 3 again highlight the cell containing the date you want to have it formatted

Step 4 This time, choose the Custom from the Category and edit the TYPE box to be ‘ddd’ if you wan the output to be Fri, or ‘dddd’ if you want the format to be ‘Friday’

Alternatively, we can have below in Excel =+TEXT(WEEKDAY(CellLocation), "ddd")