Merry Xmas from Texas
You could use a worksheet_change event in the sheet module with select case

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob" wrote in message
...
What is the code to change the font to bold and also the color In a range
in
Column D for five or six different conditions? For example:

West change to RED
East Change to BLUE
North Change to Green
Central Change to Yellow

Thanks in advance.