Thread: If statements resulting in formatting of cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default If statements resulting in formatting of cells
Hi,

Yes there is but without more detail providing a formula is difficult but
the answer lies in conditional formatting.

Mike

"Jen" wrote:

Is there a way to create a IF statement that results in the cell format
changing? For example, if the resulting value is True than the cell turns
blue, if False then the cell turns red?
Reply With QuoteReply With Quote