Thread: Can I conditionally format 1 cell to look at 5 cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default Can I conditionally format 1 cell to look at 5 cells
Assume the 5 cells are B1:B5, and A1 is the formatted cell:
=COUNTIF(B1:B5,A1)0
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"DFRESH" wrote:

I am trying to have 1 cell look at 5 cells and change color if any one of the
5 matches the 1 cell
Reply With QuoteReply With Quote