I'm trying to use a VBA macro to assign conditional formatting as it needs to be done over several different excel documents.
I have three columns, for the project name, if it is started and if it is completed.
What I want if for the project name and started column to change to orange is started...
I have code that watches three different columns for changes.
It works great when only one cell changes at a time.
But if I copy and paste multiple cells of data in to the columns at a single time, it doesn't work.
I am pretty sure that I know why, but I can't figure out how to change it to...
I am having a problem with conditional fomatting.
I have created a rule "=$I$14<=TODAY()" which does exactly what I want to do.
My issue is when I apply this same rule to a number of cells "=$I$4:$I$66<=TODAY()" it will either format all or none. It will not format each cell individually...
I reviewed several post on using VBA to insert a time and date stamp when data in a row changed and implemented on that changed one column if anything in the row changed. I then tried modifying it to insert stamps in different locations to track different cells in the row. The result is the...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.