Thread: How do i have a check display with any data entry in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SteveG
 
Posts: n/a
Default How do i have a check display with any data entry in a cell

Insert the check mark symbol you want from the Insert-Symbol menus into
a reference cell for your formula. Then your formula in B2 would be.


=IF(A20,$H$2,"")

A2 is where the data is entered by the teachers, $H$2 is where you
inserted the check mark symbol for your reference. You can then drag
this down for each row of data.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=486297

Reply With QuoteReply With Quote