View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nilou Nilou is offline
external usenet poster
 
Posts: 1
Default How do I use Conditinal Format for another cell?

Assuming

Cell A1 is the value "Red" or "Green" or "Yellow"

How could I have a formula on Cell "C1" containing Conditional formatin the
same as below

if A1 is "Red" then Bacground of A1 turns to red
if A1 is "Blue" then Bacground of A1 turns to Blue
if A1 is "Yellow" then Bacground of A1 turns to Yellow