View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aemuk
 
Posts: n/a
Default How do I change color pattern based upon a formula within a cell?

EXCEL - Can anybody show me the specific keystrokes to direct a cell to be a
certain color pattern based on the following example?

If the entered data in B1 is data in A1, then make the color pattern in B1
Green
If the entered data in B1 is < data in A1, then make the color pattern in B1
Red
If the entered data in B1 is = data in A1, then make the color pattern in B1
Yellow

Thanks for your help!