View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default how to make cell turn red or green? Please help...

You need to use Conditional Formatting, on the Format menu. Basically
you specify a condition and then choose the formatting you want to
apply if that condition is met.

Hope this helps.

Pete

On May 9, 1:24*pm, "Nevermind" wrote:
In a row I have a one cell which is drop down list so I can choose a) or b)
value.

How can I make thet if I choose a) value, whole row turn green, or when I
choose b) value, whole row turn red?

Thanks...