B
bec
If i want a row to turn red when todays date is equal to or passed the date
in a cell what formula do i use?
in a cell what formula do i use?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gizmo63
Hi bec,
For this I'm assuming row 6 and the cell containing the relevant date is D6.
Select row (or better still just the cells containing data within row 6),
then 'Format - Conditional Formatting'
Select 'Formula is' in the first drop-down, then enter this formula:
=if(D6<=TODAY(),true)
Then click the 'Format' button to choose how you want the cells to be shown
when the condition is true.
There's a lot more you can do with this so check out the Excel help for
further features.
If you copy the format down more rows the conditional format will go with it.#
HTH
Giz
For this I'm assuming row 6 and the cell containing the relevant date is D6.
Select row (or better still just the cells containing data within row 6),
then 'Format - Conditional Formatting'
Select 'Formula is' in the first drop-down, then enter this formula:
=if(D6<=TODAY(),true)
Then click the 'Format' button to choose how you want the cells to be shown
when the condition is true.
There's a lot more you can do with this so check out the Excel help for
further features.
If you copy the format down more rows the conditional format will go with it.#
HTH
Giz
B
BrianH
Hi bec and gizmo
You actually only need to enter =d6<=today()
Cheers
BrianH
You actually only need to enter =d6<=today()
Cheers
BrianH
G
Gizmo63
Ah... the If without saying 'IF'
Very true Brian, it is simpler but a personal preference. I was once
presented with a Russian spreadsheet to trace, the writer had used loads of
'IF's that didn't state 'IF'.
'twas a nightmare I vowed never want to repeat or create!!!!!!!!!
Very true Brian, it is simpler but a personal preference. I was once
presented with a Russian spreadsheet to trace, the writer had used loads of
'IF's that didn't state 'IF'.
'twas a nightmare I vowed never want to repeat or create!!!!!!!!!
B
BrianH
Not really - each to his own,of course, and lots of ways to skin a cat, but .
.. .
Excel allows you to write arithmetic expressions, using arithmetic operators
such as +, -, *, /, and functions such as SUM(), SUMPRODUCT(), to return
numerical values, and also logical expressions, using logical operators such
as >, <, =, <>, >=, <=, and functions such as AND(), and OR(), to return
logical values of TRUE or FALSE.
The IF() function has as its first argument something that can be evaluated
to TRUE or FALSE. Often this will be a logical expression, though it can be
arithmetical. If you simply need a value of TRUE (as in conditional
formatting), I prefer to simply calculate it: "If TRUE then TRUE else FALSE"
seems to me to be a rather pointless use of IF().
I personally find logical expressions very useful: I find if I'm going to
use the same test in multiple IF() functions that it's often better to
calculate the logical value once, and then use it multiple times - see e.g.
my use of TRUE / FALSE flags (calculated once, then used in 2 columns of
calcs) 9 items below this one. Can make the flow and audit of a large model
a lot easier, particlarly if the logical expressions are a bit complex.
But as I say, each to his own.
Cheers
BrianH
.. .
Excel allows you to write arithmetic expressions, using arithmetic operators
such as +, -, *, /, and functions such as SUM(), SUMPRODUCT(), to return
numerical values, and also logical expressions, using logical operators such
as >, <, =, <>, >=, <=, and functions such as AND(), and OR(), to return
logical values of TRUE or FALSE.
The IF() function has as its first argument something that can be evaluated
to TRUE or FALSE. Often this will be a logical expression, though it can be
arithmetical. If you simply need a value of TRUE (as in conditional
formatting), I prefer to simply calculate it: "If TRUE then TRUE else FALSE"
seems to me to be a rather pointless use of IF().
I personally find logical expressions very useful: I find if I'm going to
use the same test in multiple IF() functions that it's often better to
calculate the logical value once, and then use it multiple times - see e.g.
my use of TRUE / FALSE flags (calculated once, then used in 2 columns of
calcs) 9 items below this one. Can make the flow and audit of a large model
a lot easier, particlarly if the logical expressions are a bit complex.
But as I say, each to his own.
Cheers
BrianH