Conditional Formating

I have cell that uses a vlookup formula to give me a date. (I.E. look for a
date in one cell and match it to a text statement and then add a number (1,
2, etc to it) based on the text. What I want is to conditional format (color
code) the cell so that if the date is less than, equal to or great than it
will change along with the date. I tried using the conditions based on a cell
with =now() formula. I am not getting the correct color format and I suspect
it is because the date format includes time but I am not sure. If I hard code
the date then the conditional format color code works. Are the any work
arounds short of hard coding the date?
.

Relevant Pages

  • Re: Find cell value, set cell shading
    ... conditional format and paste it over the range, I will wipe out the manual ... through each cell individually inside your macro seeing if its ColorIndex ... I have now copied to a distant part of Worksheet A the status of each task ...
    (microsoft.public.excel.programming)
  • Re: recognizing cell.interior.colorindex
    ... Bill Roberts ... "Dave Peterson" wrote: ... conditional format stays with the cells, ... But if I changed the CF (in my test cell, ...
    (microsoft.public.excel)
  • Re: Find cell value, set cell shading
    ... I may be missing something, but if you have copied over the data with the task status of Complete in them to Columns CG:CU starting at Row 14, why can't you still use a simple Conditional Format? ... then I would think you would get the result you want without having to loop through each cell individually inside your macro seeing if its ColorIndex needs to be changed or not. ... I have now copied to a distant part of Worksheet A the status of each task ...
    (microsoft.public.excel.programming)
  • RE: Conditional Formatting Adding Wrong Formula
    ... So even though I am adding the conditional format as a string, ... MS Office Master 2000 ed. ... to with with the cell that is 1 row and 0 columns offset from that cell. ... which is what sForm is equal to when I run the code. ...
    (microsoft.public.excel.programming)
  • Re: recognizing cell.interior.colorindex
    ... conditional format stays with the cells, ... "Dave Peterson" wrote: ... But if I changed the CF (in my test cell, ... It sets the colorindex to -4142, ...
    (microsoft.public.excel)