| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Conditional formatting - change text colour when enteringsame name more than 3 times
I am keeping a spreadsheet that lists applications for free funding.
Applicants are only allowed free funding on 3 occasions. So, if an applicant applies for a fourth time I would like the text in the cell for the new application to change to a different colour. Column A is where I enter the name of the applicant who is applying and it’s this column I would like the formatting on. Is this something I could do with conditional formatting, if so I’d appreciate your help? Thanks Thomas |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Conditional formatting - change text colour when enteri
With Cell A2 active, Format, Conditional Formatting, FormulaIs:
=COUNTIF($A$2:$A2,A2)3 - Select Pattern Color, OK Out Paint A2 to A3:A1000 Should be fine " wrote: I am keeping a spreadsheet that lists applications for free funding. Applicants are only allowed free funding on 3 occasions. So, if an applicant applies for a fourth time I would like the text in the cell for the new application to change to a different colour. Column A is where I enter the name of the applicant who is applying and its this column I would like the formatting on. Is this something I could do with conditional formatting, if so Id appreciate your help? Thanks Thomas |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Conditional formatting - change text colour whenenteri
On 6 Sep, 15:55, JMay wrote:
With Cell A2 active, Format, Conditional Formatting, FormulaIs: =COUNTIF($A$2:$A2,A2)3 * *- Select Pattern Color, OK Out Paint A2 to A3:A1000 Should be fine " wrote: I am keeping a spreadsheet that lists applications for free funding. Applicants are only allowed free funding on 3 occasions. *So, if an applicant applies for a fourth time I would like the text in the cell for the new application to change to a different colour. *Column A is where I enter the name of the applicant who is applying and it’s this column I would like the formatting on. *Is this something I could do with conditional formatting, if so I’d appreciate your help? Thanks Thomas- Hide quoted text - - Show quoted text - This is exactly the solution I was looking for - Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - Code to colour 3+ text values differently | Excel Discussion (Misc queries) | |||
| How can I change the default fill colour in excel 2007 | Excel Discussion (Misc queries) | |||
| change tab colour when using conditional formatting in a cell | Excel Worksheet Functions | |||
| colour formatting does not show on screen at all times | Excel Discussion (Misc queries) | |||
| Excel - conditional formating on graphs. Change colour on a value | Charts and Charting in Excel | |||
Hybrid Mode
