Hi I have a spreadsheet where I have used conditional formatting which works fine, however I am wanting the rule to run on a macro so have recorded a macro to highlight sales greater than 2000 and sales lower than 2000 which turns the row red and green, the conditonal formatting worked fine but this did not run on the macro. I also recorded a further macro to remove all conditional formatting on the spreadsheet and then expected to click the button for high sales and this to work but nada.
Any suggestions folks.
Bookmarks