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

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

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