Greeting,

I have a spreadsheet where I need to high light rows which have a time
value of 0:00 in column B. Column B has many time figures and a few
empty cells. I am interested only in those cells with the value of
"0:00" (12:00 o'clock midnight)

How do I detect this time value in column B and what would a CF
formula look like to do this?

Any help will be greatly appreciated, thanks.

-Minitman

try using =0 in the Conditional formatting

"Minitman" wrote:

Greeting,

I have a spreadsheet where I need to high light rows which have a time
value of 0:00 in column B. Column B has many time figures and a few
empty cells. I am interested only in those cells with the value of
"0:00" (12:00 o'clock midnight)

How do I detect this time value in column B and what would a CF
formula look like to do this?

Any help will be greatly appreciated, thanks.

-Minitman

=AND($B1=0,$B1<"")


"Minitman" wrote:

Greeting,

I have a spreadsheet where I need to high light rows which have a time
value of 0:00 in column B. Column B has many time figures and a few
empty cells. I am interested only in those cells with the value of
"0:00" (12:00 o'clock midnight)

How do I detect this time value in column B and what would a CF
formula look like to do this?

Any help will be greatly appreciated, thanks.

-Minitman

Thanks for the quick and helpful replies.

12:00 o'clock being equal to "0" is what I was missing.

And thank you Teethless mama for the code, it works great.

-Minitman


On Thu, 27 Nov 2008 08:15:01 -0800, Teethless mama
wrote:

=AND($B1=0,$B1<"")


"Minitman" wrote:

Greeting,

I have a spreadsheet where I need to high light rows which have a time
value of 0:00 in column B. Column B has many time figures and a few
empty cells. I am interested only in those cells with the value of
"0:00" (12:00 o'clock midnight)

How do I detect this time value in column B and what would a CF
formula look like to do this?

Any help will be greatly appreciated, thanks.

-Minitman

I spoke to soon!!

The code works if there is something in B (which is what it is
supposed to do). However, if there is nothing in B, then it fires as
well (which it is NOT supposed to do).

Any ideas as to how to fix this bug?

Any help is appreciated/

-Minitman




On Thu, 27 Nov 2008 10:54:52 -0600, Minitman
wrote:

Thanks for the quick and helpful replies.

12:00 o'clock being equal to "0" is what I was missing.

And thank you Teethless mama for the code, it works great.

-Minitman


On Thu, 27 Nov 2008 08:15:01 -0800, Teethless mama
wrote:

=AND($B1=0,$B1<"")


"Minitman" wrote:

Greeting,

I have a spreadsheet where I need to high light rows which have a time
value of 0:00 in column B. Column B has many time figures and a few
empty cells. I am interested only in those cells with the value of
"0:00" (12:00 o'clock midnight)

How do I detect this time value in column B and what would a CF
formula look like to do this?

Any help will be greatly appreciated, thanks.

-Minitman

Firstly check that you've got TM's formula correctly, and make sure that
you've used CF's "Formula Is", not "Cell Value Is".

Secondly, are you sure that B1 is really empty when you say it is? What
does =LEN(B1) say? Perhaps you've got one or more spaces in the cell?
--
David Biddulph

"Minitman" wrote in message
...
I spoke to soon!!

The code works if there is something in B (which is what it is
supposed to do). However, if there is nothing in B, then it fires as
well (which it is NOT supposed to do).

Any ideas as to how to fix this bug?

Any help is appreciated/

-Minitman




On Thu, 27 Nov 2008 10:54:52 -0600, Minitman
wrote:

Thanks for the quick and helpful replies.

12:00 o'clock being equal to "0" is what I was missing.

And thank you Teethless mama for the code, it works great.

-Minitman


On Thu, 27 Nov 2008 08:15:01 -0800, Teethless mama
wrote:

=AND($B1=0,$B1<"")


"Minitman" wrote:

Greeting,

I have a spreadsheet where I need to high light rows which have a time
value of 0:00 in column B. Column B has many time figures and a few
empty cells. I am interested only in those cells with the value of
"0:00" (12:00 o'clock midnight)

How do I detect this time value in column B and what would a CF
formula look like to do this?

Any help will be greatly appreciated, thanks.

-Minitman

Hey David,

Thanks for the reply.

In response to your questions:

1st - I copied and pasted it into the CF. I had to make a couple of
adjustments (first row is 2 not 1) other wise just as it was written.
And I used the formula is in the CF.

2nd - I tried putting a space into B2 and that untriggered the CF. I
then plugged in your =LEN(B2) and it returned 0 if there was nothing
in B2 and the CF was triggered. I put in the number 0 into B2 and the
CF stayed triggered. I then removed the 0 from B2 and put in a space
like you mentioned. That got a response, the CF untriggered back to
default (no color if there is anything other then a zero).

So why is the CF Triggering on both 0 and ""??? I thought that B2<""
would exclude the empty condition. I guess not.

It seems that the only work around is to NOT let that row be empty (if
empty, put a space character into the offending cell so it will not be
empty).

-Minitman



On Thu, 27 Nov 2008 19:23:38 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

Firstly check that you've got TM's formula correctly, and make sure that
you've used CF's "Formula Is", not "Cell Value Is".

Secondly, are you sure that B1 is really empty when you say it is? What
does =LEN(B1) say? Perhaps you've got one or more spaces in the cell?