Hello,
I am trying to create a VBA code that will affect all cells from J2 to BZ1000.
Column I shows the revised milestone date
COlumn G shows the % complete
COlumn F shows the RAG status
Column J to BZ show a calendar (one week per column).
I have 4 conditions:
=IF(J3<$I3,0,IF($G3<1,AND($F3="G",ISNUMBER(J3)),0)) then J3 colour should be green
=IF(J3<$I3,0,IF($G3<1,AND($F3="A",ISNUMBER(J3)),0)) then J3 colour should be amber
=IF(J3<$I3,0,IF($G3<1,AND($F3="R",ISNUMBER(J3)),0)) then J3 colour should be red
=IF G3=100%, then J3 colour should be blue.
Any idea how to repsent this in VBA code please?
Thanks so much!
A:)
Configuration: Windows XP Internet Explorer 6.0
Access provides for conditional formatting without the messy CASE SELECT or IF-THEN statements. For an excellent review, look at http://msdn.microsoft.com/en-us/library/aa139965(office.10).aspx |
Conditional format in vba Conditional formating in vba using with commmand Conditional formatting between two figures Conditional formatting excel if blank cell, display message Conditional formatting if value is 10 % Copy conditional formatted cells and hold format Excel 08 for macs conditional formatting borders Excel conditional format if date color Excel conditional formatting an external cell Excel conditional formatting and if formula and countif Excel formula change cell color -"conditional formatting" Excel if statements check box How can i return the value of a cell and the format in if statement If statements checkbox two values in excel List of examples using if statement More than one condition in single if condition and or && || in shell script Using 2 sum if statements in one formula in excel Using the and condition in an if statement