Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I change the format of one cell by placing a tick in another?
Hi
Can I change the format of one cell by placing a tick in another? Thanks Gary |
#2
|
|||
|
|||
Use conditional formatting. eg if the tick is in A1 and you want B1 to
change, set the conditional formatting to Formula is and enter =A1="ü" where ü is translated to a tick when Wingdings is selected. If you use a different character for the tick, copy the character in the Excel formula bar and paste it into the formula. -- Ian -- "garygrung" wrote in message ... Hi Can I change the format of one cell by placing a tick in another? Thanks Gary |
#3
|
|||
|
|||
one way:
in cell B1 Formatconditional formatingchange cell value is to formula is =if(a1<"",true,false) assumes the tick is in A1 and you are changing the format in B1. Any entry in A1 will change the format HTH "garygrung" wrote: Hi Can I change the format of one cell by placing a tick in another? Thanks Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
format cell from data input to output form | Excel Worksheet Functions | |||
Cell references change when entering new data | New Users to Excel | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
notification by email by cell format change | Excel Worksheet Functions |