View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dkstech dkstech is offline
external usenet poster
 
Posts: 2
Default conditional formatting

I've read most of the similar topic posts but still haven't quite figured out
what to do. I used to teach computer science so I know conditionals, I just
don't know how to put it in Excel ( we're using 2007). What I have is a
workbook set up for time keeping. If someone enters a P in any cell I need
it to Add 1 to the AL column of that row, but if they enter a lower case p it
needs to add only 0.5 to the AL column of the row. For the same cell, if the
value entered was X or x, the AK column of the row is updated by those same
values. Thanks for any responses!