Change rowcolor in Listview depending on value excel vba

Dear friends,

Is it possible to format rows in listview according to status: I need a conditional formatting like this:
1- When Column 13 value is "Down" ,I want the whole row in my listview becomes red.
2- When Column 13 value is "Up" ,I want the whole row in my listview becomes green.

Another thing i would like to do is to change the time and date format inside listview
1. Date change to - dd/mm/yy
2. Time change to - hh:mm

i've search tons of example but could't find one, i hope someone can help me with this.
Attached herewith is the excel file


Waiting for your reply.Thanks in advance,

http://www.vbaexpress.com/forum/show...ng-in-Listview cross-post link added by Moderator --6SJ

You cannot format individual rows of a ListView (or ListBox, or ComboBox).

I think it’s possible to do because i once saw a video whereby it change the color based on status in the listview

When you have found it please post back on this site as no doubt a great number of us would like to incorporate it into our apps.

One from the depth of my archives - posted on this site in the distant past.
The O.P. wanted to highlight entries that had data missing in column 3 of the listbox.
You may be able to incorporate such a procedure.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

Since you are a new member I have done this for you but please follow all rules in the future.