VBA for Conditional Format

Hi All,

I'm looking to use VBA to conditionally format a sheet and could use some help. I am attempting to add a fill color to a row (A:E) based on three conditions:

Condition 1: Fill the row Red (Color Index 3) if Date 2 is <= Date 3

Condition 2: Fill the row Green (Color Index 5) if Date 1 is >= Date 3

Condition 3: Fill the row Blue (Color Index 20) if Date 1 is >= Date 3 and the text in column B for that row has an indent > 0

If none of these condtions are met, there is no color.

I originaly set the conditional formatting the normal way with an "And" formula, but the way a macro inputs the data into this sheet does not allow for that to work, so thats why I need to set it in VBA.

Any help would be greatly appreciated, thanks!

Originally Posted by bulina2k

there you go

Please Login or Register  to view this content.

Hello bulina2K, thanks for the repy!
How can I change the fill color to fill Range A:H vs the entire row?
Thanks!

Originally Posted by VBA-Programmer

Hi
Here is a guide for formatting ranges:
http://www.software-solutions-online...d-ranges-/c8sj

And here is a guide for selecting ranges:
http://www.software-solutions-online...-of-cells/c1vh

Let me know if you are still having trouble.

---

Hire one of our VBA programmers for only 10$/hour

Thank you very much for the resources!

Originally Posted by bulina2k

replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Thank you, that works great! I just have one more question- the interior color 4 doesnt appear to be filling at all, it fills with color 20 regardless of whether the text in column B is indented or not. How do I get this to work on text that is not indented?
Here is the code I am using-

Please Login or Register  to view this content.

Thanks!

Originally Posted by bulina2k

why did you modified the code and put

Please Login or Register  to view this content.

where I put

Please Login or Register  to view this content.

there's your answer...

Sorry, I forgot about that change. When I use the 32 the row fill color will be 4 regardless if the text is indented or not. The indented text should be color 20 if it meets the date criteria.
Thanks!