HI,

Conditional format is alright, however, need something more fancy...

rgds,

rudy

" wrote:

Is it okay if the cell changes color is the % is above 20%?
If so, why not consider using Conditional Formatting?