Can I change the format of one cell by placing a tick in another?

I

Ian

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.
 
G

Guest

one way:
in cell B1 Format>conditional formating>change 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing font using conditional formatting 1
Create If statement that returns a tick when true 3
tick mark.! 3
Conditional Formatting - 2003 to 2007 4
cells formatted to tick when text value "Y" if or null if "N" 7
tick box, how to set up 9
Number stored as text 3
VB Code for clearing Cells 2

Top