Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shading cells that contain formulas and conditional formatting at thesame time.
Dear Experts:
I got cells in one table of a worksheet that contain ... .... formulas as well as conditional formatting (i.e. there are cells that contain both attributes) I would like to fill these cells (containing formulas as well as conditional formatting at the same time) with a certain shadefill (RGB 177, 177, 177) with the aid of a VBA macro. Help is much appreciated. Thank you very much in advance. Regards, Andreas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shading cells that contain formulas and conditional formatting at thesame time.
Hello, Union(Cells.SpecialCells(xlCellTypeFormulas, 23), Cells.SpecialCells(xlCellTypeAllFormatConditions)) .Interior.Color = RGB(0, 255, 0) you may have to complete the formula selection. bye andreashermle;739265 Wrote: Dear Experts: I got cells in one table of a worksheet that contain ... .... formulas as well as conditional formatting (i.e. there are cells that contain both attributes) I would like to fill these cells (containing formulas as well as conditional formatting at the same time) with a certain shadefill (RGB 177, 177, 177) with the aid of a VBA macro. Help is much appreciated. Thank you very much in advance. Regards, Andreas -- FreeBird ------------------------------------------------------------------------ FreeBird's Profile: http://www.thecodecage.com/forumz/member.php?u=1701 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=207509 http://www.thecodecage.com/forumz |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shading cells that contain formulas and conditional formatting atthesame time.
On 7 Jun., 15:49, FreeBird wrote:
Hello, Union(Cells.SpecialCells(xlCellTypeFormulas, 23), Cells.SpecialCells(xlCellTypeAllFormatConditions)) .Interior.Color = RGB(0, 255, 0) you may have to complete the formula selection. bye andreashermle;739265 Wrote: Dear Experts: I got cells in one table of a worksheet that contain ... .... formulas as well as conditional formatting (i.e. there are cells that contain both attributes) I would like to fill these cells (containing formulas as well as conditional formatting at the same time) with a certain shadefill (RGB 177, 177, 177) with the aid of a VBA macro. Help is much appreciated. Thank you very much in advance. Regards, Andreas -- FreeBird ------------------------------------------------------------------------ FreeBird's Profile:http://www.thecodecage.com/forumz/member.php?u=1701 View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=207509 http://www.thecodecage.com/forumz Hi FreeBird, thank you very much for your professional help. Exactly what I wanted. Great job. Regards, Andreas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting for cells with formulas | Excel Worksheet Functions | |||
Cell shading with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
Conditional Formatting Shading For Visible Rows Only | Excel Discussion (Misc queries) | |||
conditional formatting-shading | Excel Worksheet Functions |