General discussion

Locked

Excel, conditional formating of cell

By ralphg_hoo ·
I need a cell to change color based on the age of a range of cells. For example, if a range of cells has not been updated in two days, I would like a particular cell to change color(red). To simplify, I need a simple indicator that data in cells have not been updated for sometime.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel, conditional formating of cell

by halleyc In reply to Excel, conditional format ...

use iif function

Collapse -

Excel, conditional formating of cell

by ralphg_hoo In reply to Excel, conditional format ...

Poster rated this answer

Collapse -

Excel, conditional formating of cell

by SyscoKid In reply to Excel, conditional format ...

Apply conditional formats to cells

1. Select the cells you want to format.

2. On the Format menu, click Conditional Formatting.

3. To use values in the selected cells as the formatting criteria, click Cell Value Is, select the comparison phrase and then type a value in the appropriate box. You can enter a constant value or a formula; you must include an equal sign (=) before the formula.

To evaluate data or a condition other than the values in the selected cells, use a formula as the formatting criteria. Click Formula Is in the box on the left, and then enter the formula in the box on the right. The formula must evaluate to a logical value of TRUE or FALSE.

4. Click Format.
5. Select the font style, font color, underlining, borders, shading, or patterns you want to apply.

Microsoft Excel applies the selected formats only if the cell value meets the condition or if the formula returns a value of TRUE.

6. To add another condition, click Add, and then repeat steps 3-5.

You can specify up to three conditions.

Tips

? You can copy conditional formats to other cells. Select the cells that have the conditional formats you want to copy, click Format Painter, and then select the cells you want to have thesame conditional formats. To copy only the conditional formats, select cells you want to format and include at least one cell in the selection that has the conditional formats you want to copy. Click Conditional Formatting on the Format menu, and then click OK.

? If you specify multiple conditions and more than one condition is true, Microsoft Excel applies only the formats of the first true condition.

? If none of the specified conditions are true, the cells keep their existing formats.

Collapse -

Excel, conditional formating of cell

by ralphg_hoo In reply to Excel, conditional format ...

Sounds like he copied the help file from Excel or something.

Collapse -

Excel, conditional formating of cell

by PrinterManager In reply to Excel, conditional format ...
Collapse -

Excel, conditional formating of cell

by ralphg_hoo In reply to Excel, conditional format ...

Poster rated this answer

Collapse -

Excel, conditional formating of cell

by el flush san In reply to Excel, conditional format ...

Ok here goes.

There is no way (traditionally) to track cell changes (you might want to look up 'History Worksheet' though) so here is what I propose:

1. Create a tracking speadsheet (Sheet B).
2. Select the range in Sheet A that is relevant, go to Sheet B, and Paste Special and select Values.
3. Now conditionally format Sheet A range so that if cell is the same (equal to) cell in Sheet B, then highligt.

If your reporting cycle is two days then you need to repeat steps 1 & 2 every 2 days. What this will give you is a value range against which the main sheet will compare and if there are no changes then flag it.

Collapse -

Excel, conditional formating of cell

by el flush san In reply to Excel, conditional format ...

Step 2 above should have 'Copy' before 'go to Sheet B'.

You can develop a macro to do Steps 1 & 2 for you and just run the macro every couple of days.

Collapse -

Excel, conditional formating of cell

by ralphg_hoo In reply to Excel, conditional format ...

This was quite an old question, but I revisited it with this info, good direction.

Collapse -

Excel, conditional formating of cell

by ralphg_hoo In reply to Excel, conditional format ...

This question was closed by the author

Related Discussions

Related Forums