10 replies
by halleyc
by ralphg_hoo
by syscokid
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.
by ralphg_hoo
by ralphg_hoo
by el flush san
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.
by el flush san
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.
by ralphg_hoo
by ralphg_hoo
This discussion is closed to new replies.
Trending Software posts
Sort by Trending