| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting
I have columns in excel that get formatted based on conditiona formatting. e.g. if cell G1 contains "1" then cell g2 is changed from bein automatic colour to being Blue text on grey background. The Blue text is colorindex 5. However if the conditional formatting is applied and I select the cel in the VB code the activecell.font.colorindex still returns the defaul colour rather than the current formatted colour. I need to check if the cell is a different font and if so skip it so i there any way to get the font with the conditional formatting ? Regards Bria -- wardide ----------------------------------------------------------------------- wardides's Profile: http://www.excelforum.com/member.php...fo&userid=1502 View this thread: http://www.excelforum.com/showthread.php?threadid=27730 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
![wardides[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
