View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Prompt if data is not entered after so many times

Will you have contiguous data in column A (or C or D) beyond the last
entry for column B?

Pete

On Mar 11, 11:26*pm, AceWill
wrote:
Is it possible to highlight a cell if that data has not been entered after so
many times? *For instance, if I have a column where I have entries of A,B,C,
& D and say B hasn't been entered for 7 times since the last entry of B, is
there a way to highlight that last B then? *Hopefully my question is clear
enough to understand.