Hi,

While on that cell, navigate to Format Conditional formatting and in the
cell value is, select equal 9. In the box to the right, type 9. Click on
the format button to apply a font or background colour. Click on OK. Now
when the entry in the cell is 9, the cell will appear in the select format.

To copy down/across, copy the cell with the conditional formatting and then
highlight the range over which conditional formatting has to be pasted. Now
press Alt+E+S+T.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"lardarse" wrote in message
...
i am setting up an employee absence sheet whereas people are allowed 10
days
sick leave before action is taken, i want my sheet to turn red at number 9
so
that the managers are alerted to have a meeting with the employee before
action is taken, how do i get excel text to change colour at a certain
limit