http://www.excelfox.com/forum/f22/get-displayed-cell-color-whether-from-conditional-formatting-or-not-338/
On Thu, Mar 20, 2014 at 9:33 PM, Divaker Pandey wrote:
> what is this dear?
>
> Divaker
>
>
> On Thu, Mar 20, 2014 at 9:18 PM, mrExcel4u wrote:
>
>> Try thishope it will help you...
>
what is this dear?
Divaker
On Thu, Mar 20, 2014 at 9:18 PM, mrExcel4u wrote:
> Try thishope it will help you...
>
> Sub test()
> Application.DisplayAlerts = False
> Application.ScreenUpdating = False
> Dim rng As Range
> Dim cell As Range
>
> Set rng = Application.InputBox("Select a range"
Try thishope it will help you...
Sub test()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim rng As Range
Dim cell As Range
Set rng = Application.InputBox("Select a range", Type:=8)
j = 1
For Each cell In rng
If cell.DisplayFormat.Interior.Color <> 16777215 Then
rcoun
Hi Dear
Please find attachment file.
On Thursday, 20 March 2014 6:12 PM, Vabs wrote:
Hi
What exactly you are looking for in VBA.
Thx
On Thu, Mar 20, 2014 at 2:04 PM, Divaker Pandey wrote:
Hi Expert,
>
>can any one please share code to retrieve already applied conditional
>formattin
Do you want this or something else?
Sub fc()
Dim cf As FormatCondition
For Each cf In Sheet13.Range("a1").FormatConditions
Debug.Print cf.Formula1
Debug.Print cf.Interior.Color
Debug.Print cf.Font.Color
Debug.Print cf.NumberFormat
Debug.Print cf.AppliesTo.Address
Debug.Pri
Hi
What exactly you are looking for in VBA.
Thx
On Thu, Mar 20, 2014 at 2:04 PM, Divaker Pandey wrote:
> Hi Expert,
>
> can any one please share code to retrieve already applied conditional
> formatting on a cell or range of excel workbook through vba.
>
>
> Thank & Regards,
>
> Divaker
>
> -
Hi Expert,
can any one please share code to retrieve already applied conditional
formatting on a cell or range of excel workbook through vba.
Thank & Regards,
Divaker
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook pag
