Nother Excel Question
Author
Discussion

Smiler.

Original Poster:

11,752 posts

261 months

Monday 26th February 2007
quotequote all
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

3,863 posts

295 months

Monday 26th February 2007
quotequote all
yep - conditional formatting.

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

Smiler.

Original Poster:

11,752 posts

261 months

Monday 26th February 2007
quotequote all
Cheers FG, sorted.