# Off topic - excel vba

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2001-01-24 10:04 UTC
**Views:** 614
**Replies:** 3
**URL:** https://www.epiusers.help/t/off-topic-excel-vba/2048

---

## Post #1 by @system

<div id="ygrps-yiv-1236012757">One thing about microsoft,  they NEVER remove features.  They just hide them<br/>
and call them &quot;undocumented&quot;<br/>
Shirley Graver<br/>
(End User)<br/>
Sys Admin<br/>
Rubber associates Inc.<br/>
Cleveland/Akron<br/>
<br/>
  -----Original Message-----<br/>
  From: Keith . Mailloux [mailto:<a rel="nofollow" target="_blank" href="mailto:kmailloux@...">kmailloux@...</a>]<br/>
  Sent: Wednesday, January 24, 2001 9:43 AM<br/>
  To: &#39;<a rel="nofollow" target="_blank" href="mailto:vantage@egroups.com">vantage@egroups.com</a>&#39;<br/>
  Subject: RE: [Vantage] OFF TOPIC - EXCEL VBA<br/>
<br/>
<br/>
  Shirley,<br/>
  I forgot all about that, since going to Excel 2000 the menu features which<br/>
  are not used are hidden. I don&#39;t use that feature much and forgot all<br/>
about<br/>
  it. It worked great thanks. I guess I&#39;ll turn the menu hide feature off.<br/>
<br/>
  -----Original Message-----<br/>
  From: Shirley H. Graver [mailto:<a rel="nofollow" target="_blank" href="mailto:shirleyg@...">shirleyg@...</a>]<br/>
  Sent: Wednesday, January 24, 2001 9:03 AM<br/>
  To: <a rel="nofollow" target="_blank" href="mailto:vantage@egroups.com">vantage@egroups.com</a><br/>
  Subject: RE: [Vantage] OFF TOPIC - EXCEL VBA<br/>
<br/>
<br/>
  In excel, under the FORMAT menu, is a selection called CONDITIONAL<br/>
  FORMATING.  This selection allows you to set up just such conditional<br/>
  requirements.  Its quite a nifty tool.<br/>
<br/>
  Shirley Graver<br/>
  (End User)<br/>
  Sys Admin<br/>
  Rubber associates Inc.<br/>
  Cleveland/Akron<br/>
<br/>
        eGroups Sponsor<br/>
<br/>
        Choose 3 DVDs for $0.49 each!<br/>
<br/>
<br/>
  To unsubscribe from this group, send an email to:<br/>
  <a rel="nofollow" target="_blank" href="mailto:vantage-unsubscribe@egroups.com">vantage-unsubscribe@egroups.com</a><br/>
<br/>
<br/>
<br/>
<br/>
<br/>
[Non-text portions of this message have been removed]</div>

---

## Post #2 by @system

<div id="ygrps-yiv-744490901">I need some help. I want to write a macro to evaluate the contents (numeric)<br/>
of a cell and change the background color based on the evaluation. Example:<br/>
If the value of cell A12 &gt; 40 turn the background Red. I know I can change<br/>
the font color based on a custom format but I need to change the background<br/>
not the font color. I wrote a macro to change the color but I can&#39;t figure<br/>
out the syntax for the evaluation of the cell contents.<br/>
<br/>
Please contact me off list so I don&#39;t bother the other members. Thanks.....</div>

---

## Post #3 by @system

<div id="ygrps-yiv-1067338522">In excel, under the FORMAT menu, is a selection called CONDITIONAL<br/>
FORMATING.  This selection allows you to set up just such conditional<br/>
requirements.  Its quite a nifty tool.<br/>
<br/>
Shirley Graver<br/>
(End User)<br/>
Sys Admin<br/>
Rubber associates Inc.<br/>
Cleveland/Akron<br/>
<br/>
  -----Original Message-----<br/>
  From: Keith . Mailloux [mailto:<a rel="nofollow" target="_blank" href="mailto:kmailloux@...">kmailloux@...</a>]<br/>
  Sent: Wednesday, January 24, 2001 8:36 AM<br/>
  To: &#39;<a rel="nofollow" target="_blank" href="mailto:vantage@egroups.com">vantage@egroups.com</a>&#39;<br/>
  Subject: [Vantage] OFF TOPIC - EXCEL VBA<br/>
<br/>
<br/>
  I need some help. I want to write a macro to evaluate the contents<br/>
(numeric)<br/>
  of a cell and change the background color based on the evaluation.<br/>
Example:<br/>
  If the value of cell A12 &gt; 40 turn the background Red. I know I can change<br/>
  the font color based on a custom format but I need to change the<br/>
background<br/>
  not the font color. I wrote a macro to change the color but I can&#39;t figure<br/>
  out the syntax for the evaluation of the cell contents.<br/>
<br/>
  Please contact me off list so I don&#39;t bother the other members.<br/>
Thanks.....<br/>
<br/>
        eGroups Sponsor<br/>
<br/>
        Get 3 CDs for ONLY $9.99!<br/>
<br/>
<br/>
  To unsubscribe from this group, send an email to:<br/>
  <a rel="nofollow" target="_blank" href="mailto:vantage-unsubscribe@egroups.com">vantage-unsubscribe@egroups.com</a><br/>
<br/>
<br/>
<br/>
<br/>
<br/>
[Non-text portions of this message have been removed]</div>

---

## Post #4 by @system

<div id="ygrps-yiv-527397094">Shirley,<br/>
I forgot all about that, since going to Excel 2000 the menu features which<br/>
are not used are hidden. I don&#39;t use that feature much and forgot all about<br/>
it. It worked great thanks. I guess I&#39;ll turn the menu hide feature off.<br/>
<br/>
-----Original Message-----<br/>
From: Shirley H. Graver [mailto:<a rel="nofollow" target="_blank" href="mailto:shirleyg@...">shirleyg@...</a>]<br/>
Sent: Wednesday, January 24, 2001 9:03 AM<br/>
To: <a rel="nofollow" target="_blank" href="mailto:vantage@egroups.com">vantage@egroups.com</a><br/>
Subject: RE: [Vantage] OFF TOPIC - EXCEL VBA<br/>
<br/>
<br/>
In excel, under the FORMAT menu, is a selection called CONDITIONAL<br/>
FORMATING.  This selection allows you to set up just such conditional<br/>
requirements.  Its quite a nifty tool.<br/>
<br/>
Shirley Graver<br/>
(End User)<br/>
Sys Admin<br/>
Rubber associates Inc.<br/>
Cleveland/Akron</div>

---


**Canonical:** https://www.epiusers.help/t/off-topic-excel-vba/2048
**Original content:** https://www.epiusers.help/t/off-topic-excel-vba/2048