I been racking my brain to figure out a way to do this. What I have is a equipment list that has either Due Hours or Due Dates. I would like to have the format for the cell entry to be tied to an adjacent cell say, that would have either Number or Date in it to tell the entry cell which custom format to apply to the entered data. Does anyone have any ideas for me. I have tried Conditional Formatting but it is only for Font Style.
Thanks,
Ken
Thanks,
Ken