Nother Excel Question

[Smiler.]

Dear PH guru's

Is it possible to change the font colour of a cell depending upon the value?
What I want to achieve is:

for less that say 10, the number is RED. Anything over, the number is BLACK.

Thanks in advance.

[FunkyGibbon]

yep - conditional formatting.

best bet is to search the excel help for conditional formatting - it will give you examples.

[Smiler.]

Cheers FG, sorted.