ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Condition Formatting in code. How? (https://www.excelbanter.com/excel-programming/370106-re-condition-formatting-code-how.html)

Barb Reinhardt

Condition Formatting in code. How?
 
This should help

http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm

"Corey" wrote:



I am trying to set up the above CF in code instead.
I also need to set a 4th colour if the above formula=(c8:r30-TODAY())=1 and colour this white

I do not know how to begin this?

Corey...



All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com