Conditional formatting macro (highlight macro)

I have two problems with a macro which is essentially a highlight macro that used conditional formatting.

I have a workbook with 20 sheets (R1-R20). In those sheets I want to highlight row A-F based on the contents of F. This is simple enough, but for some reason I cannot have it accept conditional formatting on all twenty pages in one go (or actually it works fine, but not when I run the macro - the macro only works on the first page). It does however work if I do on every single page (20 times).

The code below is what I recorded, but which dowsn't work. It only inserts conditional formatting on sheet R1.

Please Login or Register  to view this content.

How do I make insert conditional formatting on every page (except for doing manually on every single page)?

Secondly I dont know how to get input for the macro. Preferrably I'd like a pop up box which would ask for the three possible conditions, i.e.
condition 1 -> color the row green
condition 2 -> color the row red
condition 3 -> color the row blue
The user would then enter the value for conditional check.
I'm clueless on how to do this.

/Møller

Please Login or Register  to view this content.

not sure what you want to acheive with the conditions!

You do not need to select anything in order to manipulate it!

I want to color the cell green if the value is 5229.

The select is to unselect the selected cells (those that I apply the conditional formatting to). By selecting c30 (which contains no value) I make sure the user does delete something by accident.

I'm not saying it's beautiful code.

/Møller