Thread: how do i put color in a cell based on data in a second cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darrilyn Darrilyn is offline
external usenet poster
  
Posts: 19
Default how do i put color in a cell based on data in a second cell
Conditional formatting should work. Tell me what you put in the
conditionally formating boxes.

"Diogie" wrote:

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