Thread: how do i put color in a cell based on data in a second cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Diogie Diogie is offline
external usenet poster
  
Posts: 21
Default how do i put color in a cell based on data in a second cell
Cell A1 has 8 digit number manually entered each day.
Cell B1 has a single letter manually entered each day (same time as A1 entry).
The background color of cell A1 will be determined by the single letter in B1.
I've looked at conditional formatting, but haven't had much luck. I'm
running excel 2003.

Can anyone help?
Reply With QuoteReply With Quote