LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting - Code to colour 3+ text values differently AK9955 Excel Discussion (Misc queries) 3 November 9th 09 06:11 PM
How can I change the default fill colour in excel 2007 Simon Lovatt Excel Discussion (Misc queries) 0 February 12th 08 10:58 AM
change tab colour when using conditional formatting in a cell julie s Excel Worksheet Functions 6 October 23rd 06 09:13 PM
colour formatting does not show on screen at all times mamonkey Excel Discussion (Misc queries) 1 October 21st 06 07:49 AM
Excel - conditional formating on graphs. Change colour on a value Peter Shore Charts and Charting in Excel 5 June 9th 06 06:10 AM


All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"