CarlYaxley
New Member
- Joined
- Jan 28, 2015
- Messages
- 10
Hi all,
Debut post
! Been visiting this site for a while but FINALLY i haven't found an answer and must now post.
So i'm looking for a method that maybe really simple using an assigned number per colour cell, use the number as reference return sub total. But IDEALLY i'm quite simply looking to Count cells that have been conditional formatted. Maybe then Macro this to self count.. whatever! haha
This sheet is used daily so it will be super quick if its possible. Basically i've used conditional formatting to highlight products containing text like "TB" as it's not always at the beginning of the cell (Cannot use =left2 therefore)..
I' really need the number returned in a cell too as I read online Macro can return it as a pop-up message box. (Pointless really!)![Stick out tongue :p :p](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Any tips, formulas or VBA Greatly appreciated!
Debut post
So i'm looking for a method that maybe really simple using an assigned number per colour cell, use the number as reference return sub total. But IDEALLY i'm quite simply looking to Count cells that have been conditional formatted. Maybe then Macro this to self count.. whatever! haha
This sheet is used daily so it will be super quick if its possible. Basically i've used conditional formatting to highlight products containing text like "TB" as it's not always at the beginning of the cell (Cannot use =left2 therefore)..
I' really need the number returned in a cell too as I read online Macro can return it as a pop-up message box. (Pointless really!)
Any tips, formulas or VBA Greatly appreciated!