Thread: A macro to color the cells according to the values existing in a c
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default A macro to color the cells according to the values existing in a c
Use conditional formatting

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Zancouth" wrote in message
...
Hi,

Does anyone know if it is possible to do a macro that would automatically
color the rows RED( for example ) according to the values in a column ?

E.g. at col B, when the value is IN , the entire row would be colored
blue.
when the value is OUT , the entire row would be colored red.





Reply With QuoteReply With Quote