Is there a way to do basically a reverse of the conditional formatting -
where the certain cells have a pattern assigned to them already, and is there
a way to in another column have that change to either a numeric value or even
a true false.

Like if cell A1 has a red background have B1 come up with sometype of a
number that would be different that if the background was blank.

Why not use the value that has caused the other cell to come up red.

So if your conditional formatting for A1 depends on say the content
being greater than 10, then using an if statement in B1 to insert the
value you want =if(A110,Value you want).

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=512291

Because there are not values that caused the coloring - that was entered by
hand

"EdMac" wrote:


Why not use the value that has caused the other cell to come up red.

So if your conditional formatting for A1 depends on say the content
being greater than 10, then using an if statement in B1 to insert the
value you want =if(A110,Value you want).

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=512291

Then it isn't conditional formatting.

You will need a function, like this

Function CI(rng as Range)
If rng.Count 1 Then
CI = cvErr(xlErrRef)
Else
Ci = rng.Interior.Colorindex
End If
End Function

and in your cell, use

=IF(CI(A1)=3,99,100)

which tests for Red.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steve Curtis" wrote in message
...
Because there are not values that caused the coloring - that was entered
by
hand

"EdMac" wrote:


Why not use the value that has caused the other cell to come up red.

So if your conditional formatting for A1 depends on say the content
being greater than 10, then using an if statement in B1 to insert the
value you want =if(A110,Value you want).

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile:
http://www.excelforum.com/member.php...o&userid=30736
View this thread:
http://www.excelforum.com/showthread...hreadid=512291

Thanks Bob, that works great - but here is another question - I know that the
3 is for Red, how do I find out what the other related numbers are for other
colors?


"Bob Phillips" wrote:

Then it isn't conditional formatting.

You will need a function, like this

Function CI(rng as Range)
If rng.Count 1 Then
CI = cvErr(xlErrRef)
Else
Ci = rng.Interior.Colorindex
End If
End Function

and in your cell, use

=IF(CI(A1)=3,99,100)

which tests for Red.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steve Curtis" wrote in message
...
Because there are not values that caused the coloring - that was entered
by
hand

"EdMac" wrote:


Why not use the value that has caused the other cell to come up red.

So if your conditional formatting for A1 depends on say the content
being greater than 10, then using an if statement in B1 to insert the
value you want =if(A110,Value you want).

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile:
http://www.excelforum.com/member.php...o&userid=30736
View this thread:
http://www.excelforum.com/showthread...hreadid=512291

Steve,

See this previous post from myself and Peter T, most are given there
http://tinyurl.com/annkb

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steve Curtis" wrote in message
...
Thanks Bob, that works great - but here is another question - I know that
the
3 is for Red, how do I find out what the other related numbers are for
other
colors?


"Bob Phillips" wrote:

Then it isn't conditional formatting.

You will need a function, like this

Function CI(rng as Range)
If rng.Count 1 Then
CI = cvErr(xlErrRef)
Else
Ci = rng.Interior.Colorindex
End If
End Function

and in your cell, use

=IF(CI(A1)=3,99,100)

which tests for Red.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steve Curtis" wrote in message
...
Because there are not values that caused the coloring - that was
entered
by
hand

"EdMac" wrote:


Why not use the value that has caused the other cell to come up red.

So if your conditional formatting for A1 depends on say the content
being greater than 10, then using an if statement in B1 to insert
the
value you want =if(A110,Value you want).

Ed


--
EdMac

------------------------------------------------------------------------
EdMac's Profile:
http://www.excelforum.com/member.php...o&userid=30736
View this thread:
http://www.excelforum.com/showthread...hreadid=512291