Can I set more than three criteria for conditional formatting?
I would like randomly repeated names in column C to set the colour of the
font in column A (or for the colour of the font for the entire row). If I use conditional formatting I can only set three names from column C. However I have more names (8 - 10 ) in column C. Am using Office 2003. |
The next step up after you can no longer use conditional formatting is to use an Change Event macro http://www.mvps.org/dmcritchie/excel/condfmt.htm#case There is an addin that would work the same as conditional formatting --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "River" wrote in message ... I would like randomly repeated names in column C to set the colour of the font in column A (or for the colour of the font for the entire row). If I use conditional formatting I can only set three names from column C. However I have more names (8 - 10 ) in column C. Am using Office 2003. |
Take a look at http://xldynamic.com/source/xld.CFPlus.Download.html
-- HTH Bob Phillips "River" wrote in message ... I would like randomly repeated names in column C to set the colour of the font in column A (or for the colour of the font for the entire row). If I use conditional formatting I can only set three names from column C. However I have more names (8 - 10 ) in column C. Am using Office 2003. |
All times are GMT +1. The time now is 09:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com