Re: if then statements

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andy B (andyb_at_takethisbitout.dawsons.co.uk)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 14:04:47 -0000

Hi

AFAIK, this can only be done with VBA. Have a look here for more info:
http://www.cpearson.com/excel/colors.htm#RGB

Depending on what you are wanting, you may be able to use Conditional
Formatting.

Hope this helps.

Andy.

"halconegro" <anonymous@discussions.microsoft.com> wrote in message
news:ADE2F35B-A923-4C30-8341-039325B45F21@microsoft.com...
> How do I color a cell based on an if then statement?
> thanks

Relevant Pages

  • Re: macros
    ... What colors are you wanting to use (or is it sufficient to return the ... STDEV worksheet functions) would only increase the nesting levels to ... Changing colors would require VBA, since conditional formatting only ...
    (microsoft.public.excel.misc)
  • Re: how to calculate the time of solar terms
    ... Thanks for the info, HORIZONS looks nice, but I want an offline ... What specifically are you wanting to calculate? ... Depending upon what it is, ...
    (sci.astro)
  • selections based on a option button and a combo box.
    ... depending on the user's selection of a option button, ... My code in VBA actually does the following: ... even when the user selects some county from the 'Counties_State' combo ...
    (microsoft.public.access.forms)
  • Re: selections based on a option button and a combo box.
    ... > depending on the user's selection of a option button, ... My code in VBA actually does the following: ... > county but, the Else part is not being executed. ...
    (microsoft.public.access.forms)
  • Re: VBA -Recordset
    ... What method in VBA can be used to move through a recordset then ... read every single field/row and then update it depending on the value? ...
    (comp.databases.ms-access)