To apply number formatting: Select the cells(s) you want to modify. Selecting a cell range. Click the drop-down arrow next to the Number Format command on the Home tab. The Number Formatting drop-down menu will appear. Select the desired formatting option. The selected cells will change to the new formatting style. Format Cells 1. Enter the value 0.8 into cell B2. Select cell B2. Right click, and then click Format Cells (or press CTRL + 1). For example, select Currency. On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.
I have some data and based on the amount of time someone gives me to complete the work I want to change the cell color. I break my tiers into the following: 5 days or less Red 6 to 14 days Orange 15 to 29 days Yellow 30 or more days Blue So I would have a date of the show and a current date. So if Show date was and current date was 12/01/15, I would have a cell which would show 30 for the remainingg days and I would want this to automatically fill the cell blue based on this number.
If todays date was the cell would be red because only 4 days are left. What kind of formula could I use to make this happen? Hello, you need four conditional formats, one for each color. Select the cell. In the screenshot I selected cell A2. The formula will use the currently selected cell.
Create a conditional format with a formula, using =A2-TODAY()>=30 Format to blue. Note that there are no $ signs in the cell reference. A2 is the current cell and using no $ signs in the formula will look at the current cell when you apply the format to other cells. Create three more formats with these formulas: =A2-TODAY() Formats to copy the conditional format to other cells. Let me know if that works for you. Northwestern university.
___________________ cheers, teylyn Community Moderator www.teylyn.com. Hi, Try this 1. Suppose Date of show is in cell A2 and Today's date is in cell B2 2. In cell C2, enter this formula =A2-B2 3. Click on cell C2 and go to Home > Conditional formatting > New Rule > Use a formula to determine which cells to format 4. In the Formula bar there, enter this formula =C2 Fill > Red > OK > Apply 6. Repeat the steps above for the other conditions as well The formulas would be: =AND(C2>=6,C2=15,C2=30 Hope this helps.
Regards, Ashish Mathur www.ashishmathur.com http://twitter.com/excelashish.
By Many Excel 2010 worksheets use percentages in the form of interest rates, growth rates, inflation rates, and so on. When you apply the Percent Style format to a value that has already been entered in a cell, Excel multiplies the value by 100 and displays the result with a percent sign.