How to get only rows in result sheet

[simplymanasmandal]

I have written the VBA code to color any figure above 15, but it display rows above 15 as red including other rows.
Below is the VBA code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Which shows the output as Workbook1.jpg but my query is how to get output which contains only rows above 15 with red

[GC Excel]

What do you want to do exactly?

You want to color full row only if all values in this row are > 15?

[simplymanasmandal]

Thanks for reply
I am expecting output like this

" "	A	B	C	D	E
1	4	8	12	16	20
2	5	10	15	20	25
3	6	12	18	24	30
4	7	14	21	28	35
5	8	16	24	32	40
6	9	18	27	36	45
7	10	20	30	40	50

[Winon]

Hello simlymanasmandal,

Delete your VBA Code for ColorCells, and handle that with Conditional formatting.

A sample Workbook, would have been of much greater help though.

Regards.

[GC Excel]

Hi,
If I understand correctly what you want, please try this code :

Please Login or Register  to view this content.