Conditional Formatting in Table...


1

116

I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David
 
Ad

Advertisements

S

Stefan B Rusynko

I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David
 
1

116

Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David
 
S

Stefan B Rusynko

Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David
 
1

116

Hello Stefan. I jumped the gun on this one. When I attempt to save the page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Stefan B Rusynko said:
Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

Stefan B Rusynko said:
I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David


.

.
 
K

Kathleen Anderson

Where did you make your changes? You should find the code you want to modify
in the gray-colored code and make your changes. Save the changes while still
in Code view. You will notice that once you've saved your changes they are
also made to the maroon colored code - that is by design. The maroon colored
code should never be touched; it's generated by the gray code at save time.


--

~ Kathleen Anderson
Microsoft MVP - Expression Web
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


116 said:
Hello Stefan. I jumped the gun on this one. When I attempt to save the
page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Stefan B Rusynko said:
Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all
with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that
with a
couple of tweaks, it can be used in a variety of places?

David

Stefan B Rusynko said:
I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results
values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default
(say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup
conditional
formatting based on the results. I am not sure if a table or text
fields are
preferred for this. Also where to locate the necessary coding to
perform
this. An example...>60 and <80 would be blue, and greater than 80
would be
green.

Thanks for any assist
David


.

.
 
Ad

Advertisements

S

Stefan B Rusynko

The conditional results formatting the OP wants to add is not a change to the webbot code and needs to be done in the results table
html, and not in the webbot code
- see my post above with instructions I provided

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Where did you make your changes? You should find the code you want to modify
in the gray-colored code and make your changes. Save the changes while still
in Code view. You will notice that once you've saved your changes they are
also made to the maroon colored code - that is by design. The maroon colored
code should never be touched; it's generated by the gray code at save time.


--

~ Kathleen Anderson
Microsoft MVP - Expression Web
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


116 said:
Hello Stefan. I jumped the gun on this one. When I attempt to save the
page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Stefan B Rusynko said:
Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all
with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that
with a
couple of tweaks, it can be used in a variety of places?

David

Stefan B Rusynko said:
I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results
values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default
(say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup
conditional
formatting based on the results. I am not sure if a table or text
fields are
preferred for this. Also where to locate the necessary coding to
perform
this. An example...>60 and <80 would be blue, and greater than 80
would be
green.

Thanks for any assist
David


.

.
 
S

Stefan B Rusynko

Post the actual Html code for just the table cell, from code view, including the td tags containing the value of your DBRW table
that you are trying to conditionally format

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan. I jumped the gun on this one. When I attempt to save the page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Stefan B Rusynko said:
Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

Stefan B Rusynko said:
I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David


.

.
 
1

116

Hello Stefan,

allset. I see that I went after the code within webbot. I have a question
though. Some of the data entered is N/A. When any of the results contain
this value, the page will not display. If I change the value to a number,
the problem goes away. Thoughts?

David

Stefan B Rusynko said:
Post the actual Html code for just the table cell, from code view, including the td tags containing the value of your DBRW table
that you are trying to conditionally format

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan. I jumped the gun on this one. When I attempt to save the page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Stefan B Rusynko said:
Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

Stefan B Rusynko said:
I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David


.

.

.
 
S

Stefan B Rusynko

Presume by N/A you mean the filed value is empty or a Null field in your database
- that will normally cause result and code errors when a value in the database is expected

If your DB field is numeric, in the database you should make it a required field and set a default value of say 0
If the field is actually a text field (with numbers in it), you could do the same and set the same default
- then fill all empty field with the default value

Alternatively you could check for an empty field (length =0) or Null field, with VBscript to prevent errors with the
IsNumeric(fp_rs("YOURFIELDNAME")) and display "N/A" for the value

<td>
<%
strColor="std"
IF NOT IsNull(fp_rs("YOURFIELDNAME")) AND Len(fp_rs("YOURFIELDNAME"))>0 THEN
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
END IF
%>
<span class="<%=strColor%>">
<% IF NOT IsNull(fp_rs("YOURFIELDNAME")) AND Len(fp_rs("YOURFIELDNAME"))>0 THEN %>
fp_rs("YOURFIELDNAMEHERE")
<% ELSE %>
N/A
<% END IF %>
</span>
</td>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan,

allset. I see that I went after the code within webbot. I have a question
though. Some of the data entered is N/A. When any of the results contain
this value, the page will not display. If I change the value to a number,
the problem goes away. Thoughts?

David

Stefan B Rusynko said:
Post the actual Html code for just the table cell, from code view, including the td tags containing the value of your DBRW table
that you are trying to conditionally format

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan. I jumped the gun on this one. When I attempt to save the page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Stefan B Rusynko said:
Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

Stefan B Rusynko said:
I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David


.

.

.
 
Ad

Advertisements

1

116

Thanks Stefan. Issue resolved. Prior to using DB throught the web, the user
was leaving fields empty.

Thanks again,
David

Stefan B Rusynko said:
Presume by N/A you mean the filed value is empty or a Null field in your database
- that will normally cause result and code errors when a value in the database is expected

If your DB field is numeric, in the database you should make it a required field and set a default value of say 0
If the field is actually a text field (with numbers in it), you could do the same and set the same default
- then fill all empty field with the default value

Alternatively you could check for an empty field (length =0) or Null field, with VBscript to prevent errors with the
IsNumeric(fp_rs("YOURFIELDNAME")) and display "N/A" for the value

<td>
<%
strColor="std"
IF NOT IsNull(fp_rs("YOURFIELDNAME")) AND Len(fp_rs("YOURFIELDNAME"))>0 THEN
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
END IF
%>
<span class="<%=strColor%>">
<% IF NOT IsNull(fp_rs("YOURFIELDNAME")) AND Len(fp_rs("YOURFIELDNAME"))>0 THEN %>
fp_rs("YOURFIELDNAMEHERE")
<% ELSE %>
N/A
<% END IF %>
</span>
</td>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan,

allset. I see that I went after the code within webbot. I have a question
though. Some of the data entered is N/A. When any of the results contain
this value, the page will not display. If I change the value to a number,
the problem goes away. Thoughts?

David

Stefan B Rusynko said:
Post the actual Html code for just the table cell, from code view, including the td tags containing the value of your DBRW table
that you are trying to conditionally format

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello Stefan. I jumped the gun on this one. When I attempt to save the page
after pasting and editing the criteria, FP wont save the changes since the
area is auto generated by FP (webbot) I'm guessing. Is there away around
this so FP will save the change?

David

Stefan B Rusynko said:
Yes
you can apply classic ASP code to many parts of the DBRW
- even to the extent of eliminating the DBRW completely and doing it all with custom code
See
http://www.w3schools.com/asp/default.asp
and
http://www.w3schools.com/ado/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks for the assist. Works well. Looking at this, it appears that with a
couple of tweaks, it can be used in a variety of places?

David

:

I'm guessing you are talking about a Data Results Table (from the DBRW)
- set the results as a table
One column will be the numeric values you are checking the results values for <60, 60-80 & >80
- with a field name of say: YOURFIELDNAME

First set up three style classes for the blue and green, and default (say black) text in the head section of the page
<style type="text/css">
..blue {color: Blue;}
..green {color: Green;}
..std {color: Black;}
<style>

Then Find your display cell for that value in you results in code view
- it will look something like
<td>fp_rs("YOURFIELDNAME")</td>

And change it to

<td>
<%
strColor="std"
IF IsNumeric(fp_rs("YOURFIELDNAME")) THEN
IF fp_rs("YOURFIELDNAME")>=60 AND fp_rs("YOURFIELDNAME")<=80 THEN
strColor="blue"
ELSEIF fp_rs("YOURFIELDNAMEHERE")>80 THEN
strColor="green"
ELSE
strColor="std"
END IF
END IF
%>
<span class="<%=strColor%>">fp_rs("YOURFIELDNAMEHERE")</span>
</td>



_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a Results table with 7 columns. I would like to setup conditional
formatting based on the results. I am not sure if a table or text fields are
preferred for this. Also where to locate the necessary coding to perform
this. An example...>60 and <80 would be blue, and greater than 80 would be
green.

Thanks for any assist
David


.



.

.

.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top