LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 41
Default to find the conditiona format of a cell in vba

I have conditional format in C2
the condition is
c2 is grater than B2
I can find this out by selecting C2 and see
format(menu)-conditional format
But is it possible to find out the condtion in vba I am thinking on the
lines

dim x
x=range("c2").formatcondtions(1)

it gives error.

any sugestions or is this not possible?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditiona format based on format of another cell Tami Excel Worksheet Functions 1 December 18th 09 04:48 AM
Conditiona format Sverre Excel Discussion (Misc queries) 0 April 27th 09 01:10 PM
Vlookup 2 conditiona Little Penny Excel Discussion (Misc queries) 13 October 19th 06 01:56 AM
find word in a cell then change cell format [email protected] Excel Programming 2 May 23rd 05 01:21 PM
how do I search for any cell containing data and apply conditiona. Dawn Excel Discussion (Misc queries) 1 April 20th 05 10:59 AM


All times are GMT +1. The time now is 07:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"