I have a conditional formatting warning on some cells so that if the date in
B3 is older than today the background goes red

Formula is = (TODAY()-B3)0

How would I write this so that the action is to go red unless there is a *
on cell B10 ?

Thanks

--
Tobit

Hi
Try
=AND((TODAY()-B3)0,B10<"*")
Tina
"TC" wrote:

I have a conditional formatting warning on some cells so that if the date in
B3 is older than today the background goes red

Formula is = (TODAY()-B3)0

How would I write this so that the action is to go red unless there is a *
on cell B10 ?

Thanks

--
Tobit

Tina - works a treat - thank you.

OK, one step further. Can I use conditional formatting to turn the
background from red to green is there is a * in B10 - or is this sort of
multiple formats too much for it (using Excel97)

--
Tobit

"tina" wrote in message
...
Hi
Try
=AND((TODAY()-B3)0,B10<"*")
Tina
"TC" wrote:

I have a conditional formatting warning on some cells so that if the date
in
B3 is older than today the background goes red

Formula is = (TODAY()-B3)0

How would I write this so that the action is to go red unless there is a
*
on cell B10 ?

Thanks

--
Tobit

Hi TC
To do this you need to do one conditioning format for red then select add
button and conditioning 2 will appear and you can enter formula where
resulting formatting is green
=AND((TODAY()-B3)0,B10<"*") conditioning1 formula
=AND((TODAY()-B3)0,B10="*") conditioning2 formula
I presume this is available in excel97 as I am using excel2000
Tina



"TC" wrote:

Tina - works a treat - thank you.

OK, one step further. Can I use conditional formatting to turn the
background from red to green is there is a * in B10 - or is this sort of
multiple formats too much for it (using Excel97)

--
Tobit

"tina" wrote in message
...
Hi
Try
=AND((TODAY()-B3)0,B10<"*")
Tina
"TC" wrote:

I have a conditional formatting warning on some cells so that if the date
in
B3 is older than today the background goes red

Formula is = (TODAY()-B3)0

How would I write this so that the action is to go red unless there is a
*
on cell B10 ?

Thanks

--
Tobit

Tina - your a star- many thanks

Tobit

Hi TC
To do this you need to do one conditioning format for red then select
add
button and conditioning 2 will appear and you can enter formula where
resulting formatting is green
=AND((TODAY()-B3)0,B10<"*") conditioning1 formula
=AND((TODAY()-B3)0,B10="*") conditioning2 formula
I presume this is available in excel97 as I am using excel2000
Tina



"TC" wrote:

Tina - works a treat - thank you.

OK, one step further. Can I use conditional formatting to turn the
background from red to green is there is a * in B10 - or is this sort of
multiple formats too much for it (using Excel97)

--
Tobit

"tina" wrote in message
...
Hi
Try
=AND((TODAY()-B3)0,B10<"*")
Tina
"TC" wrote:

I have a conditional formatting warning on some cells so that if the
date
in
B3 is older than today the background goes red

Formula is = (TODAY()-B3)0

How would I write this so that the action is to go red unless there is
a
*
on cell B10 ?

Thanks

--
Tobit

Tina I have a problem and NEED HELP IMMEDIATELY. I would sincerely
appreciate your any help you can give me.

I am creating this spreadsheet. That shows dates for:
1. Completed on time (yellow)
2. Completed ahead of target date (green)
3. Past Target Date (red)
I NEED THE "COMPLETION DATE" column NOT to turn ANY color if there is no
date in the column AND TO Turn a color (yellow, green, red) if there is a
date in the "completion date" column.

It seems to me that I am needing 4 conditioning formatting:
PLEASE HELP AND TELL ME WHAT THE FORMULAS COULD BE.

"TC" wrote:

Tina - your a star- many thanks

Tobit

Hi TC
To do this you need to do one conditioning format for red then select
add
button and conditioning 2 will appear and you can enter formula where
resulting formatting is green
=AND((TODAY()-B3)0,B10<"*") conditioning1 formula
=AND((TODAY()-B3)0,B10="*") conditioning2 formula
I presume this is available in excel97 as I am using excel2000
Tina



"TC" wrote:

Tina - works a treat - thank you.

OK, one step further. Can I use conditional formatting to turn the
background from red to green is there is a * in B10 - or is this sort of
multiple formats too much for it (using Excel97)

--
Tobit

"tina" wrote in message
...
Hi
Try
=AND((TODAY()-B3)0,B10<"*")
Tina
"TC" wrote:

I have a conditional formatting warning on some cells so that if the
date
in
B3 is older than today the background goes red

Formula is = (TODAY()-B3)0

How would I write this so that the action is to go red unless there is
a
*
on cell B10 ?

Thanks

--
Tobit