On May 16, 3:59*am, lardarse
wrote:
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

Select the entire sheet by clicking on the square between the column
and row labels.
Now Select FORMATCONDITIONAL FORMATTING.
Select the FORMULA IS option Under the CONDITION 1 label.
Enter the following in the formula box to the right: =$A$1=9
Where A1 is the address of the cell that contains the data that is
being monitored