View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default If statements resulting in formatting of cells

Check out FormatConditional Formatting


Gord Dibben MS Excel MVP

On Wed, 15 Oct 2008 08:07:02 -0700, 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?