View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] tomfabtastic@hotmail.com is offline
external usenet poster
 
Posts: 13
Default Create If statement that returns a tick when true

Hi,

I would like to show a tick in a cell if the value of the cell
alongside is equal to one.

I can put a tick in a cell using Insert-Symbol-change font to Wing-
Dings and select the tick.

However, if I now try to put a If statement around this tick (which
shows as a P in the cell) everything shows as Wing Ding characters.

Any idea how I can have an If statement that returns a tick when
statement is true.

Thanks,
Tom