Conditional Formating using Dates
= ... sorry, wasn't sure you didn't know how to do conditional formats...
just woke up while ago :o
"Will" wrote:
Perfect!! Now, when the current date is the same as the date entered into
the cell it turns clear so what's the sign for greater than or equal to in
formula speak?
"Bob Phillips" wrote:
Select all of the target cells, let's assume the first is B3
Goto CF, FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =B3<TODAY()
Select Pattern tab
Select a colour
OK out
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Will" wrote in message
...
1. I need a my cells containing dates to highlight red when the current
date
passes the date within the cell (basically I need to know when things are
behind).
2. How do I copy a conditional format from one cell and have it apply to
a
different one (basically I want to do a series). I've even tried using
the
special paste tool and selected formating and it still applies to the
original cell and not the new one(ie: format 1 =R5C7 and when copied to
row
7, column 7 it will still format to =R5C7 instead of =R7C7). There are no
$
in the formula to be removed so it will do a series (I read this in
someone
else's post). How can I do this?
|