if then formula excel conditional formatting

#If then formula excel conditional formatting how to#

Select two other symbols for tasks that are pending (clock) and delayed tasks (phone). If you are using symbols that are from a non-standard font such as Wingdings 2, you have to ensure that the cells are formatted with that particular font. If you change the font of this cell back to the standard font, it would show you the letter P. When you click on the cell containing the inserted symbol, for example the check mark, you will see on the formula bar that it actually puts a letter “P” which is formatted in Wingdings 2 font to look like a check mark. Notice that it inserts that icon in the selected cell on your spreadsheet. Click on a symbol you want to use, then click Insert.There are a lot of symbols available for Arial, but in this example, let’s take symbols from Wingdings 2.

While you can use the symbols that are available in Conditional Formatting Icon Sets, you can also use your own personalized icons. Label that as Done (Y), where you can input “Y” if a task has been completed. Cell A1 = Today()Īdd a column that would serve as an indication if you have completed the task. Since today’s date will be used as reference for overdue tasks, use the TODAY() function to automatically insert today’s date every time the workbook is opened. Rather than just seeing the end date of each task, using symbols can help you see their individual status visually.

#If then formula excel conditional formatting how to#

(The link to how to use the WORKDAY() function is found here ). The end date is calculated by the WORKDAY() function according to the number of working days specified. The example shows a project time plan with tasks, start date and end date. I use a combination of symbols and Excel’s conditional formatting feature to achieve the below:

This way you can visually indicate which tasks are complete and which are still pending. In this example, I show you how you can use symbols and traffic light type of color coding to bring attention to tasks that are past your deadline. Project Planning – Bring Attention to Overdue Tasks You can use your own custom symbols in Excel and conditionally format them. You don’t have to choose between the icon sets available to you within Conditional Formatting, but instead choose pretty much any symbol you’d like and conditionally format this instead. You’d like to use symbols in your reports to bring attention to certain tasks or results? You find the icons available in Excel’s Conditional Formatting limited? You’d like something different to make your report stand out? How to use Own Symbols in Excel and Conditionally Format Them