Hi ,

I apologise in advance for the rudimentary nature of this post but I am
new to Macros.

What I am trying to do is create a macro that changes the colour of a
word's font after it has been typed into a cell. For example when I
type the word red into a cell I would like to be able to run a macro to
turn the entry into the word red (typed in the red font colour).

An associated question. Is it possible to have more than three types of
conditional formatting within a single spreadsheet?

thanks, Nik


---
Message posted from http://www.ExcelForum.com/