when creating a formula in excel, can you have the answer appear in a different color font?

Question

what i am trying to say, is i have one date i am entering in manually, another date is a calculated date...if one date is later than the other i want the dates red....if it is earlier, i want it green.

Answer 1

1. Select the cells for which you want to add, change, or remove conditional formatting (conditional format: A format, such as cell shading or font color, that Excel automatically applies to cells if a specified condition is true.).

2. On the Format menu, click Conditional Formatting.

3. Do one of the following:

Add a conditional format

1. Do one of the following:
To use values in the selected cells as the formatting criteria, click Cell Value Is, select the comparison phrase, and then type a constant (constant: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants. An expression, or a value resulting from an expression, is not a constant.) value or a formula. If you enter a formula, start it with an equal sign (=).

To use a formula as the formatting criteria (to evaluate data or a condition other than the values in selected cells), click Formula Is and then enter the formula that evaluates to a logical value of TRUE or FALSE.

2. Click Format.

3. Select the formatting you want to apply when the cell value meets the condition or the formula returns the value TRUE.

4. To add another condition, click Add, and then repeat steps 1 through 3.

You can specify up to three conditions. If none of the specified conditions are true, the cells keep their existing formats.

Note Using multiple conditions If more than one specified condition is true, Microsoft Excel applies only the formats of the first true condition, even if more than one condition is true.

Answer 2

Go to the Format | Conditional Formatting menu item for the target cell. This allows you to set a rule for the formatting. Choose Cell Value Is then choose Greater Than in the next box and the entered date cell in the final box. Then, just choose the format that you'd like to have.

Answer 3

There isn't a components for that, however you should utilize Conditional Formatting. Prefer the cells you want to alter colour, then decide upon the structure menu, then conditional formatting. The leisure is lovely intuitive.

Answer 4

Go to the cell in which the answer will appear and change the font for that cell to the color you want it to be.

Answer 5

You should be able to use conditional formatting but I'm not exactly sure how you can set up the exact condition you are looking for.

Answer 6

there is not any formulation for that, yet you ought to use Conditional Formatting. pick the cells you like to alter colour, then pick the format menu, then conditional formatting. something is fairly intuitive.

Answer 7

if you know how to write VB scripts you can do it. Otherwise I don't think you can with Excel functionality.

Refer to a book called Visual Basic for Dummies. It will show you in there how to do it.

Answer 8

Yes, I think you can set up a rule for that. Try using the "Help" index.

Answer 9

I did this when i took the certification class - I dont remeber sorry =)