Return adjacent cell if conditional formatting exists.
 

I have several columns. One column contains conditional formatting returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the cell next to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return column d)

Thanks,

--
Donna

Return adjacent cell if conditional formatting exists.
 

How can I set up a formula to return the adjacent cell when the cell next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can use a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the cell next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return column
d)

Thanks,

--
Donna

Return adjacent cell if conditional formatting exists.
 

Donna

See Chip Pearson's site methods of determining if and what type of CF is on a
cell.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff" wrote:

How can I set up a formula to return the adjacent cell when the cell next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can use a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the cell next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return column
d)

Thanks,

--
Donna

Return adjacent cell if conditional formatting exists.
 

All that code when a simple worksheet formula will do?

No thanks!

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Donna

See Chip Pearson's site methods of determining if and what type of CF is
on a
cell.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff" wrote:

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can use
a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return
column
d)

Thanks,

--
Donna

Return adjacent cell if conditional formatting exists.
 

Not a problem Biff

Your simple formula is spot on.

But..............Posters should know what other options are available when
someone states

"There's no way to test for conditional formatting"


Gord

On Wed, 8 Nov 2006 17:05:41 -0500, "Biff" wrote:

All that code when a simple worksheet formula will do?

No thanks!

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Donna

See Chip Pearson's site methods of determining if and what type of CF is
on a
cell.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff" wrote:

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can use
a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return
column
d)

Thanks,

--
Donna




Gord Dibben MS Excel MVP

Return adjacent cell if conditional formatting exists.
 

But..............Posters should know what other options
are available when someone states
"There's no way to test for conditional formatting"

That's true but they should also be made aware of all the caveats that
accompany those methods, which Chip seems to cover.

On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation issues.

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Not a problem Biff

Your simple formula is spot on.

But..............Posters should know what other options are available when
someone states

"There's no way to test for conditional formatting"


Gord

On Wed, 8 Nov 2006 17:05:41 -0500, "Biff" wrote:

All that code when a simple worksheet formula will do?

No thanks!

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
Donna

See Chip Pearson's site methods of determining if and what type of CF is
on a
cell.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff"
wrote:

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can
use
a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return
column
d)

Thanks,

--
Donna




Gord Dibben MS Excel MVP

Return adjacent cell if conditional formatting exists.
 

http://tinyurl.com/y6vy8y

Biff

"Biff" wrote in message
...
But..............Posters should know what other options
are available when someone states
"There's no way to test for conditional formatting"

That's true but they should also be made aware of all the caveats that
accompany those methods, which Chip seems to cover.

On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation
issues.

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Not a problem Biff

Your simple formula is spot on.

But..............Posters should know what other options are available
when
someone states

"There's no way to test for conditional formatting"


Gord

On Wed, 8 Nov 2006 17:05:41 -0500, "Biff" wrote:

All that code when a simple worksheet formula will do?

No thanks!

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Donna

See Chip Pearson's site methods of determining if and what type of CF
is
on a
cell.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff"
wrote:

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can
use
a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return
column
d)

Thanks,

--
Donna




Gord Dibben MS Excel MVP

Return adjacent cell if conditional formatting exists.
 

Again Thanks.

Valid points that should be adhered to.

Why use a UDF when Excel has a method that ensures re-calculation


Gord

On Wed, 8 Nov 2006 18:23:46 -0500, "Biff" wrote:

http://tinyurl.com/y6vy8y

Biff

"Biff" wrote in message
...
But..............Posters should know what other options
are available when someone states
"There's no way to test for conditional formatting"

That's true but they should also be made aware of all the caveats that
accompany those methods, which Chip seems to cover.

On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation
issues.

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Not a problem Biff

Your simple formula is spot on.

But..............Posters should know what other options are available
when
someone states

"There's no way to test for conditional formatting"


Gord

On Wed, 8 Nov 2006 17:05:41 -0500, "Biff" wrote:

All that code when a simple worksheet formula will do?

No thanks!

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
m...
Donna

See Chip Pearson's site methods of determining if and what type of CF
is
on a
cell.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff"
wrote:

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can
use
a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return
column
d)

Thanks,

--
Donna




Gord Dibben MS Excel MVP




Gord Dibben MS Excel MVP

Return adjacent cell if conditional formatting exists.
 

Biff ! Thank you!
Regarding:
On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation issues.<<

THAT is one of my major hot buttons!
Um....I think this might be a rant.....
Color coding is great if the application is a human...but, we're using Excel!
If we want to enter information into a worksheet, flag it, then have Excel
aggregate, cull, sum, etc those flagged items, we need to use flags that
Excel can "SEE"! I always train my Excel users to use data flags (1's vs
0's, X's, whatever) then let Conditional Formatting color the items. That way
they get what they want (eye catching colors) by using a technique that works
with Excel, instead of against it, and lends itself to automated data
analysis.

Yup...that was a rant...not a big one...but, still a rant. (sorry)

*********
**
Regards,
Ron

XL2002, WinXP


"Biff" wrote:

But..............Posters should know what other options
are available when someone states
"There's no way to test for conditional formatting"

That's true but they should also be made aware of all the caveats that
accompany those methods, which Chip seems to cover.

On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation issues.

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Not a problem Biff

Your simple formula is spot on.

But..............Posters should know what other options are available when
someone states

"There's no way to test for conditional formatting"


Gord

On Wed, 8 Nov 2006 17:05:41 -0500, "Biff" wrote:

All that code when a simple worksheet formula will do?

No thanks!

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
Donna

See Chip Pearson's site methods of determining if and what type of CF is
on a
cell.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff"
wrote:

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can
use
a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return
column
d)

Thanks,

--
Donna




Gord Dibben MS Excel MVP

Return adjacent cell if conditional formatting exists.
 

Are you trying to say that Excel isn't an adult coloring book? <g

Biff

"Ron Coderre" wrote in message
...
Biff ! Thank you!
Regarding:
On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation
issues.<<

THAT is one of my major hot buttons!
Um....I think this might be a rant.....
Color coding is great if the application is a human...but, we're using
Excel!
If we want to enter information into a worksheet, flag it, then have Excel
aggregate, cull, sum, etc those flagged items, we need to use flags that
Excel can "SEE"! I always train my Excel users to use data flags (1's vs
0's, X's, whatever) then let Conditional Formatting color the items. That
way
they get what they want (eye catching colors) by using a technique that
works
with Excel, instead of against it, and lends itself to automated data
analysis.

Yup...that was a rant...not a big one...but, still a rant. (sorry)

*********
**
Regards,
Ron

XL2002, WinXP


"Biff" wrote:

But..............Posters should know what other options
are available when someone states
"There's no way to test for conditional formatting"

That's true but they should also be made aware of all the caveats that
accompany those methods, which Chip seems to cover.

On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation
issues.

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Not a problem Biff

Your simple formula is spot on.

But..............Posters should know what other options are available
when
someone states

"There's no way to test for conditional formatting"


Gord

On Wed, 8 Nov 2006 17:05:41 -0500, "Biff"
wrote:

All that code when a simple worksheet formula will do?

No thanks!

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
Donna

See Chip Pearson's site methods of determining if and what type of CF
is
on a
cell.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff"
wrote:

How can I set up a formula to return the adjacent cell when the
cell
next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can
use
a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the
cell
next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return
column
d)

Thanks,

--
Donna




Gord Dibben MS Excel MVP

Return adjacent cell if conditional formatting exists.
 

Thank you so much for all of your input. I read every word from both of you
and sincerely appreciate your time. I will go forward crayolas in hand : )
--
Donna


"Biff" wrote:

Are you trying to say that Excel isn't an adult coloring book? <g

Biff

"Ron Coderre" wrote in message
...
Biff ! Thank you!
Regarding:
On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation
issues.<<

THAT is one of my major hot buttons!
Um....I think this might be a rant.....
Color coding is great if the application is a human...but, we're using
Excel!
If we want to enter information into a worksheet, flag it, then have Excel
aggregate, cull, sum, etc those flagged items, we need to use flags that
Excel can "SEE"! I always train my Excel users to use data flags (1's vs
0's, X's, whatever) then let Conditional Formatting color the items. That
way
they get what they want (eye catching colors) by using a technique that
works
with Excel, instead of against it, and lends itself to automated data
analysis.

Yup...that was a rant...not a big one...but, still a rant. (sorry)

*********
**
Regards,
Ron

XL2002, WinXP


"Biff" wrote:

But..............Posters should know what other options
are available when someone states
"There's no way to test for conditional formatting"

That's true but they should also be made aware of all the caveats that
accompany those methods, which Chip seems to cover.

On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation
issues.

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Not a problem Biff

Your simple formula is spot on.

But..............Posters should know what other options are available
when
someone states

"There's no way to test for conditional formatting"


Gord

On Wed, 8 Nov 2006 17:05:41 -0500, "Biff"
wrote:

All that code when a simple worksheet formula will do?

No thanks!

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
Donna

See Chip Pearson's site methods of determining if and what type of CF
is
on a
cell.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff"
wrote:

How can I set up a formula to return the adjacent cell when the
cell
next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can
use
a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the
cell
next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return
column
d)

Thanks,

--
Donna




Gord Dibben MS Excel MVP

Return adjacent cell if conditional formatting exists.
 

Thank you for the input. I will use it well. Sincerely. Donna
--
Donna


"Gord Dibben" wrote:

Again Thanks.

Valid points that should be adhered to.

Why use a UDF when Excel has a method that ensures re-calculation


Gord

On Wed, 8 Nov 2006 18:23:46 -0500, "Biff" wrote:

http://tinyurl.com/y6vy8y

Biff

"Biff" wrote in message
...
But..............Posters should know what other options
are available when someone states
"There's no way to test for conditional formatting"

That's true but they should also be made aware of all the caveats that
accompany those methods, which Chip seems to cover.

On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation
issues.

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Not a problem Biff

Your simple formula is spot on.

But..............Posters should know what other options are available
when
someone states

"There's no way to test for conditional formatting"


Gord

On Wed, 8 Nov 2006 17:05:41 -0500, "Biff" wrote:

All that code when a simple worksheet formula will do?

No thanks!

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
m...
Donna

See Chip Pearson's site methods of determining if and what type of CF
is
on a
cell.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff"
wrote:

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can
use
a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the cell
next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return
column
d)

Thanks,

--
Donna




Gord Dibben MS Excel MVP




Gord Dibben MS Excel MVP

Return adjacent cell if conditional formatting exists.
 

I hope it is so when I am bored (yeah like that will happen) then I can
entertain myself.
--
Donna


"Biff" wrote:

Are you trying to say that Excel isn't an adult coloring book? <g

Biff

"Ron Coderre" wrote in message
...
Biff ! Thank you!
Regarding:
On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation
issues.<<

THAT is one of my major hot buttons!
Um....I think this might be a rant.....
Color coding is great if the application is a human...but, we're using
Excel!
If we want to enter information into a worksheet, flag it, then have Excel
aggregate, cull, sum, etc those flagged items, we need to use flags that
Excel can "SEE"! I always train my Excel users to use data flags (1's vs
0's, X's, whatever) then let Conditional Formatting color the items. That
way
they get what they want (eye catching colors) by using a technique that
works
with Excel, instead of against it, and lends itself to automated data
analysis.

Yup...that was a rant...not a big one...but, still a rant. (sorry)

*********
**
Regards,
Ron

XL2002, WinXP


"Biff" wrote:

But..............Posters should know what other options
are available when someone states
"There's no way to test for conditional formatting"

That's true but they should also be made aware of all the caveats that
accompany those methods, which Chip seems to cover.

On the subject, I can't understand why the experts don't discourage
calculations based on formats/colors due to the inherent calculation
issues.

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Not a problem Biff

Your simple formula is spot on.

But..............Posters should know what other options are available
when
someone states

"There's no way to test for conditional formatting"


Gord

On Wed, 8 Nov 2006 17:05:41 -0500, "Biff"
wrote:

All that code when a simple worksheet formula will do?

No thanks!

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
Donna

See Chip Pearson's site methods of determining if and what type of CF
is
on a
cell.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff"
wrote:

How can I set up a formula to return the adjacent cell when the
cell
next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can
use
a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the
cell
next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return
column
d)

Thanks,

--
Donna




Gord Dibben MS Excel MVP