View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Changing text color based upon If

Check out help for Conditional Formatting


Gord Dibben MS Excel MVP

On Mon, 24 Nov 2008 10:39:02 -0800, KenM
wrote:

I have two colums with inventory numbers Column A is the three month
requirement, column B is quantity in stock. If B is less than A column, I
would like the text in B to change colors (to Red for instance). Any ideas?

Thanks,
KenM