Interior Cell Colour - Conditional Formatting
I have the following UDF that returns the interior cell colour value o a cell: Function InteriorColor(CellColor As Range) Application.Volatile InteriorColor = CellColor.Interior.ColorIndex End Function However, when I use it on a cell that has conditional formatting - an the formatting is being applied - the result is not the interior colo value of the conditional format. Does anyone know of a UDF that will recognise when a cell ha conditional formatting and give the interior cell colour if th formatting is being applied? Many Thanks -- michael.a ----------------------------------------------------------------------- michael.a7's Profile: http://www.excelforum.com/member.php...fo&userid=3302 View this thread: http://www.excelforum.com/showthread.php?threadid=53537 |
Interior Cell Colour - Conditional Formatting
http://www.cpearson.com/excel/CFColors.htm
Tim "michael.a7" wrote in message ... I have the following UDF that returns the interior cell colour value of a cell: Function InteriorColor(CellColor As Range) Application.Volatile InteriorColor = CellColor.Interior.ColorIndex End Function However, when I use it on a cell that has conditional formatting - and the formatting is being applied - the result is not the interior color value of the conditional format. Does anyone know of a UDF that will recognise when a cell has conditional formatting and give the interior cell colour if the formatting is being applied? Many Thanks. -- michael.a7 ------------------------------------------------------------------------ michael.a7's Profile: http://www.excelforum.com/member.php...o&userid=33027 View this thread: http://www.excelforum.com/showthread...hreadid=535376 |
Interior Cell Colour - Conditional Formatting
The easiest way is to replicate the same formula that the cell uses for its
conditional formatting. -- Gary''s Student "michael.a7" wrote: I have the following UDF that returns the interior cell colour value of a cell: Function InteriorColor(CellColor As Range) Application.Volatile InteriorColor = CellColor.Interior.ColorIndex End Function However, when I use it on a cell that has conditional formatting - and the formatting is being applied - the result is not the interior color value of the conditional format. Does anyone know of a UDF that will recognise when a cell has conditional formatting and give the interior cell colour if the formatting is being applied? Many Thanks. -- michael.a7 ------------------------------------------------------------------------ michael.a7's Profile: http://www.excelforum.com/member.php...o&userid=33027 View this thread: http://www.excelforum.com/showthread...hreadid=535376 |
Interior Cell Colour - Conditional Formatting
See http://www.xldynamic.com/source/xld.CFConditions.html
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "michael.a7" wrote in message ... I have the following UDF that returns the interior cell colour value of a cell: Function InteriorColor(CellColor As Range) Application.Volatile InteriorColor = CellColor.Interior.ColorIndex End Function However, when I use it on a cell that has conditional formatting - and the formatting is being applied - the result is not the interior color value of the conditional format. Does anyone know of a UDF that will recognise when a cell has conditional formatting and give the interior cell colour if the formatting is being applied? Many Thanks. -- michael.a7 ------------------------------------------------------------------------ michael.a7's Profile: http://www.excelforum.com/member.php...o&userid=33027 View this thread: http://www.excelforum.com/showthread...hreadid=535376 |
All times are GMT +1. The time now is 10:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com