| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring formatting attributes to another cell.
=IF(SUM(K9:K34)<K4*COUNT(K9:K34)*($AJ3),K2,"")
cell K2 has been formatted so the text is blue, how do i get the cell to format itself blue, should the "if" statement be true, in such a way that only changing the formatting in cell K2 would change the formatting in this current cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Transferring formatting attributes to another cell.
Formulas can't "bring" a format with them. You'd need to use conditional
formatting to test that the result of the formula is equal to K2. Biff "Neal" wrote in message ... =IF(SUM(K9:K34)<K4*COUNT(K9:K34)*($AJ3),K2,"") cell K2 has been formatted so the text is blue, how do i get the cell to format itself blue, should the "if" statement be true, in such a way that only changing the formatting in cell K2 would change the formatting in this current cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell attributes | Excel Discussion (Misc queries) | |||
| Data value display attributes linked to table attributes | Charts and Charting in Excel | |||
| Transferring contents and color of cell | Excel Worksheet Functions | |||
| Can I modify cell attributes (font,color etc.) based on function . | Excel Discussion (Misc queries) | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
Linear Mode
