Thread: Coonditional formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBeaucaire[_109_] JBeaucaire[_109_] is offline
external usenet poster
  
Posts: 1
Default Coonditional formatting

For Red:

Condition1:
Formula Is =AND(ISNUMBER(A1),A1=15)

For Green:
Condition2
Formula Is =AND(ISNUMBER(A1),A1<15)


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58335

Reply With QuoteReply With Quote