Thread: change font color if number Range changes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Moses
 
Posts: n/a
Default change font color if number Range changes
Hello,
I have a number in cell B1 that is a pasted link from a different worksheet.
I want the font color in cell B1 to change depending on what value is
displayed in B1. If <70 RED Bold, If 70 to 120 Automatic, If 120 Red Bold

Reply With QuoteReply With Quote