If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i get excel text to change colour at a certain limit
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 |
#2
|
|||
|
|||
how do i get excel text to change colour at a certain limit
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 |
#3
|
|||
|
|||
how do i get excel text to change colour at a certain limit
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 |
Thread Tools | |
Display Modes | |
|
|