Advance filtering and marking using given "in text" parameters.

[Bashi2003]

Hej everyone,

iīve got a huge Excel table to work with every day and would be happy if somebody could help me with a macro to mark som entries.

ivīgot entries like this:


17.11.2011 13:35:27 1 WEA 1/48-600/48102 (27 kW, 3.5 m/s) Asym.capacitor curr.

and this:

--.--.---- --:--:-- 2 WEA 2/MD70/70193 (730 kW, 7.5 m/s) <No Commu

What i need is a macro that marks "ok" every row with a positiv value in front of "KW" and !!no!! text "<No Commu" (every other text is allowed!)


if there is a positiv or negativ value in front of "KW" but written "<No Commu" it needs to be marked yellow

at least every row with 0 or negativ value in front of "KW" but a positiv value higher than 3,5 in front of m/s needs to be marked red


It would be a great help for my work. May somebody could help me.

BR, Sebastian