Thread: Assign Color to a Cell based on another Cell on a diff Sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VROSARIO7 VROSARIO7 is offline
external usenet poster
  
Posts: 8
Default Assign Color to a Cell based on another Cell on a diff Sheet
Hi,

I am having trouble with the following:

What I want to be able to do is change the color of cell B1 on sheet 2 once
the data on cell A1 sheet 1 is entered.

So if I entered 100% in A1 sheet 1, i want the color of B1 sheet 2 (which
also says 100%) to automatically change.

Is this possible?
Reply With QuoteReply With Quote