Conditional formatting issue

[RDOREMUS]

I HAVE AN ISSUE WITH A SPREADSHEET TO WHERE I HAVE ALL THE CONDITIONAL FORMATTING FORMULAS ENTERED BUT WAS ASKED TO ADD A NEW COLUMN WHICH CHANGES UP SOME OF THE RULES. WHAT I HAVE IS 5 COLUMNS, B, C, D, E, F.
B = AN INSPECTED DATE
C= A DATE THATS 30 DAYS AFTER THE INSPECTED DATE (B)
D= A DATE THATS 60 DAYS AFTER THE INSPECTED DATE (B)
E= A DATE THATS 90 DAYS AFTER THE INSPECTED DATE (B)
F- IS A DATE WHEN ENTERED MANUALLY WOULD GIVE COLUMN (B)'S DATE AN EXTRA 3 YEARS, WHICH SHOULD CHANGE THE COLORS AND DATES IN C, D, AND E. BUT WHEN COLUMN (F) IS BLANK THEN NO CHANGES OCCUR.

Inspected       30 Days    60 Days      90 Days        Decal issue date
       
        27-Aug-09      26-Sep-09   26-Oct-09   25-Nov-09     31-Aug-09

WHAT IVE TRIED IS INSPECTED DATE =SUM(DECAL ISSUE DATE + 1155) BUT WHEN I DO THAT IT MAKES THE 30, 60 AND 90 COLUMNS ALL CHANGE TO NO COLOR WHEN I WANT THEM TO BE GREEN. ANY HELP WOULD BE GREATLY APPRECIATED.
THE CONDITIONAL FORMATTING FORMULAS ARE AS FOLLOWED:
=IF(DATEDIF($B2,TODAY(),"d")<=30,TRUE,FALSE) - GREEN
=IF(DATEDIF($B2,TODAY(),"d")<=60,TRUE,FALSE) - YELLOW
=IF(DATEDIF($B2,TODAY(),"d")<=90,TRUE,FALSE) - ORANGE
=IF(AND($B2<>"",DATEDIF($B2,TODAY(),"d")>90),TRUE,FALSE) - RED
=IF($B2="",TRUE,FALSE) - BLANK

 

[GlennUK]

Yes im inputing that formula into c, which if it works will make d and e change accordingly as well.

So, does it change the date only if something is put into column F?

 

[Kadar]

Can someone help me plot a conditional cascade chart using the table below:
<TABLE style="MARGIN: auto auto auto 5.4pt; WIDTH: 322.95pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=431><TBODY><TR style="HEIGHT: 17.4pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 63.75pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm" vAlign=bottom width=85 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm" vAlign=bottom width=86 noWrap>

0 to 3<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm" vAlign=bottom width=86 noWrap>

3 to 6<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm" vAlign=bottom width=86 noWrap>

6 to 8<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm" vAlign=bottom width=86 noWrap>

8 to 9<o></o>​

</TD></TR><TR style="HEIGHT: 17.4pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 63.75pt; PADDING-RIGHT: 5.4pt; BACKGROUND: black; HEIGHT: 17.4pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-alt: solid windowtext 1.0pt; mso-border-bottom-alt: solid windowtext .5pt" vAlign=bottom width=85 noWrap> <o></o>
</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

A<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

B<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

C<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" vAlign=bottom width=86 noWrap>

D<o></o>​

</TD></TR><TR style="HEIGHT: 16.6pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 63.75pt; PADDING-RIGHT: 5.4pt; HEIGHT: 16.6pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext 1.0pt; mso-border-left-alt: solid windowtext 1.0pt" vAlign=bottom width=85 noWrap>

X<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 16.6pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

3<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 16.6pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

0<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 16.6pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

2<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 16.6pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

1<o></o>​

</TD></TR><TR style="HEIGHT: 16.6pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 63.75pt; PADDING-RIGHT: 5.4pt; HEIGHT: 16.6pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext 1.0pt; mso-border-left-alt: solid windowtext 1.0pt" vAlign=bottom width=85 noWrap>

Y<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 16.6pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

3<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 16.6pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

2<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 16.6pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

2<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 16.6pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

0<o></o>​

</TD></TR><TR style="HEIGHT: 17.4pt; mso-yfti-irow: 4; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 63.75pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" vAlign=bottom width=85 noWrap>

Z<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

2<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

5<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

2<o></o>​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 64.8pt; PADDING-RIGHT: 5.4pt; HEIGHT: 17.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0cm; mso-border-bottom-alt: solid windowtext .5pt" vAlign=bottom width=86 noWrap>

2<o></o>​

</TD></TR></TBODY></TABLE>
<o> </o>
Essentially X, Y and Z are columns of different sections, stacked on top of each other.
<o> </o>
CONDITIONS:
IF AX>3; that section of the stacked chart should be BLUE
IF AX=3: GREEN
IF 1<AX<3; YELLOW
IF AX<1: RED
<o> </o>
FOR EXAPLE:
Section 1) AX=3 therefore GREEN
BX=3 therefore RED
CX=2 therefore YELLOW
DX= 1 therefore YELLOW
Thank you,

 

[RDOREMUS]

so, does it change the date only if something is put into column f?

yes. . . Thats the only way the dates would change if (f) has an x in the column then the dates in c:e would change by 3 years.

 

[RDOREMUS]

can someone help me plot a conditional cascade chart using the table below:

<table class=msonormaltable style="margin: Auto auto auto 5.4pt; width: 322.95pt; border-collapse: Collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt" cellspacing=0 cellpadding=0 width=431 border=0><tbody><tr style="height: 17.4pt; mso-yfti-irow: 0; mso-yfti-firstrow: Yes"><td style="border-right: #f0f0f0; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 63.75pt; padding-top: 0cm; border-bottom: #f0f0f0; height: 17.4pt; background-color: Transparent" valign=bottom nowrap width=85></td><td style="border-right: #f0f0f0; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: #f0f0f0; height: 17.4pt; background-color: Transparent" valign=bottom nowrap width=86>

0 to 3<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

​

</td><td style="border-right: #f0f0f0; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: #f0f0f0; height: 17.4pt; background-color: Transparent" valign=bottom nowrap width=86>

3 to 6<o></o>

​

</td><td style="border-right: #f0f0f0; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: #f0f0f0; height: 17.4pt; background-color: Transparent" valign=bottom nowrap width=86>

6 to 8<o></o>

​

</td><td style="border-right: #f0f0f0; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: #f0f0f0; height: 17.4pt; background-color: Transparent" valign=bottom nowrap width=86>

8 to 9<o></o>​

</td></tr><tr style="height: 17.4pt; mso-yfti-irow: 1"><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: Windowtext 1pt solid; padding-left: 5.4pt; background: Black; padding-bottom: 0cm; border-left: Windowtext 1pt solid; width: 63.75pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 17.4pt; mso-border-alt: Solid windowtext 1.0pt; mso-border-bottom-alt: Solid windowtext .5pt" valign=bottom nowrap width=85><o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: Windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 17.4pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext 1.0pt; mso-border-top-alt: Solid windowtext 1.0pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

a<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: Windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 17.4pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext 1.0pt; mso-border-top-alt: Solid windowtext 1.0pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

b<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: Windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 17.4pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext 1.0pt; mso-border-top-alt: Solid windowtext 1.0pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

c<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: Windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 17.4pt; background-color: Transparent" valign=bottom nowrap width=86>

d<o></o>

​

</td></tr><tr style="height: 16.6pt; mso-yfti-irow: 2"><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: Windowtext 1pt solid; width: 63.75pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 16.6pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt; mso-border-right-alt: Solid windowtext 1.0pt; mso-border-left-alt: Solid windowtext 1.0pt" valign=bottom nowrap width=85>

x<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 16.6pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

3<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 16.6pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

0<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 16.6pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

2<o></o>

​

</td><td style="border-right: #f0f0f0; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 16.6pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

1<o></o>

​

</td></tr><tr style="height: 16.6pt; mso-yfti-irow: 3"><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: Windowtext 1pt solid; width: 63.75pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 16.6pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt; mso-border-right-alt: Solid windowtext 1.0pt; mso-border-left-alt: Solid windowtext 1.0pt" valign=bottom nowrap width=85>

y<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 16.6pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

3<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 16.6pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

2<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 16.6pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

2<o></o>

​

</td><td style="border-right: #f0f0f0; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 16.6pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

0<o></o>

​

</td></tr><tr style="height: 17.4pt; mso-yfti-irow: 4; mso-yfti-lastrow: Yes"><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: Windowtext 1pt solid; width: 63.75pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 17.4pt; background-color: Transparent" valign=bottom nowrap width=85>

z<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 17.4pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

2<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 17.4pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

5<o></o>

​

</td><td style="border-right: Windowtext 1pt solid; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 17.4pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt; mso-border-right-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

2<o></o>

​

</td><td style="border-right: #f0f0f0; padding-right: 5.4pt; border-top: #f0f0f0; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 64.8pt; padding-top: 0cm; border-bottom: Windowtext 1pt solid; height: 17.4pt; background-color: Transparent; mso-border-bottom-alt: Solid windowtext .5pt" valign=bottom nowrap width=86>

2<o></o>​

</td></tr></tbody></table>​

<o></o>
essentially x, y and z are columns of different sections, stacked on top of each other.
<o></o>
conditions:
if ax>3; that section of the stacked chart should be blue
if ax=3: Green
if 1<ax<3; font yellow<>
if ax<1: Red
<o></o>
for exaple:
section 1) ax=3 therefore green
bx=3 therefore red
cx=2 therefore yellow
dx= 1 therefore yellow
thank you,

you need to post that as your own original thread in the forum or noone will be able to help you because they cannot see it.

 

[GlennUK]

yes. . . Thats the only way the dates would change if (f) has an x in the column then the dates in c:e would change by 3 years.

... but, you say that the cells turn green even if the dates don't change????

 

[RDOREMUS]

Im sorry i meant to say that that formula =if($b140="","",30+if(g140="",b140,edate(b140,36)))

is to replace the formula for column c to update the dates as if an x was present in column f. It works now, but the only thing i have a problem with is that i want it to where if i take the x out of column f for the dates in column c:e to revert back to just being 30, 60 and 90 days after the date in column b. And vice versa as to if i enter an x into column f the dates in column c:e will update by 3 years.

B C D E F

<TABLE style="WIDTH: 435pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=579 border=0><COLGROUP><COL style="WIDTH: 105pt; mso-width-source: userset; mso-width-alt: 5120" width=140><COL style="WIDTH: 103pt; mso-width-source: userset; mso-width-alt: 5010" width=137><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4461" width=122><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" width=64><TBODY><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD class=xl74 id=td_post_2496672 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 105pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15.75pt; BACKGROUND-COLOR: #fac090" width=140 height=21>[FONT=Arial][SIZE=2][B]Inspected[/B][/SIZE][/FONT]</TD><TD class=xl74 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 103pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fac090" width=137>[FONT=Arial][SIZE=2][B]30 Days[/B][/SIZE][/FONT]</TD><TD class=xl74 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 92pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fac090" width=122>[FONT=Arial][SIZE=2][B]60 Days[/B][/SIZE][/FONT]</TD><TD class=xl74 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 87pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fac090" width=116>[FONT=Arial][SIZE=2][B]90 Days[/B][/SIZE][/FONT]</TD><TD class=xl74 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #fac090" width=64>[B][FONT=Arial][SIZE=2]Decal[/SIZE][/FONT][/B]</TD></TR><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>[FONT=Arial][SIZE=2]27-Aug-09[/SIZE][/FONT]</TD><TD class=xl73 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BACKGROUND: lime; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; mso-pattern: black none">[FONT=Arial][SIZE=2]26-Sep-12[/SIZE][/FONT]</TD><TD class=xl73 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BACKGROUND: lime; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; mso-pattern: black none">[FONT=Arial][SIZE=2]26-Oct-12[/SIZE][/FONT]</TD><TD class=xl73 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BACKGROUND: lime; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; mso-pattern: black none">[FONT=Arial][SIZE=2]25-Nov-12[/SIZE][/FONT]</TD><TD class=xl76 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">[B][FONT=Arial][SIZE=2]X[/SIZE][/FONT][/B]</TD></TR></TBODY></TABLE>

I HOPE THIS PART OF MY SPREADSHEET HELPS. PRETTY MUCH C:E IS FORMATED OFF OF(B). BUT IF THERE IS AN X IN (F) THEN IT SHOULD ADD 3 YEARS TO C:E. IF I TAKE THE X OUTTA COLUMN (F) THEN C:E SHOULD GO BACK TO BEING JUST THE 30, 60 AND 90 DAYS OFF OF COLUMN (B).

 

[GlennUK]

Looking at the spreadsheet part you've shown, it looks like it's working ... although your formula looks as though it wouldn't work, ( or is pointing to different cells ) .... as you seem to be testing column G, but you have shown ( and have said ) that you want the formula to test column F. So, why does your formula point to column G?

 

[RDOREMUS]

yea i noticed that right before you posted. I have changed it to wheres its pointing to F instead of G. Now everything is finally working like i originally needed it to. Thank you very much for all your help and patience.

 

[GlennUK]

Glad to help.