| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell properties and cell functions
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell properties and cell functions
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell properties and cell functions
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell properties and cell functions
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell properties and cell functions
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell properties and cell functions
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell properties and cell functions
Thanks Bob, the other question I had, is how do you get this to update those
equations or to re-calculate when you change the colors of the cells? I did check to make sure that my recalc is set to automatic already. "Bob Phillips" wrote: 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell properties and cell functions
There is the big problem. Unfortunately, changing a cell colour does not
trigger any event, so there is no automated way. The best we can do is to add this to the start of the function Application.Volatile and then when you change a colour, hit the F9 key. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Steve Curtis" wrote in message ... Thanks Bob, the other question I had, is how do you get this to update those equations or to re-calculate when you change the colors of the cells? I did check to make sure that my recalc is set to automatic already. "Bob Phillips" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel cell properties | Excel Worksheet Functions | |||
| Cell changing it's properties | New Users to Excel | |||
| How do you use EXCEL formula in properties of file (cell content) | Excel Discussion (Misc queries) | |||
| How do I show some of the file properties in a cell in a work she. | Excel Worksheet Functions | |||
| Excel document properties insert into a cell | Excel Discussion (Misc queries) | |||
Linear Mode
