Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Hi,
I'm trying to "white out" the text in a cell if a certain value is displayed (the cell has an existing formula in it already). What formula can I use in the conditional formatting window to white out multiple (about 18) specific values if they show up in the cell? And how do I maintain using my original formula in this cell if the displayed value is not one of my 18. Also, if I'm able to "white out" the cell described above, I need to "white out" the cell next to it at the same time (which has a different formula already in it). Can the formatting from the first cell be copied to the second cell if the conditions are met in the first cell? Help (and a BIG thank you!) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Trek,
For this example the cells to change color will be B2 and C2, depending on the contents of B2. Make a list somewhere with your 18 values, and name it MyList. It can be in another sheet, and can be hidden (either the cells or the entire sheet). It could even be right in the definition of the named range, though that's not as good a way. Select B2 and C2. Format - Conditional formatting. Formula is: = OR($B2 = MyList) Click the Format button, Font tab, and select the white font color. OK OK again. Note that you can do this with multiple rows at once, but the formula above is for where the active (white) cell of your selection is in row 2. Change the $B2 term accordingly if necessary. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "trekguy1" wrote in message ... Hi, I'm trying to "white out" the text in a cell if a certain value is displayed (the cell has an existing formula in it already). What formula can I use in the conditional formatting window to white out multiple (about 18) specific values if they show up in the cell? And how do I maintain using my original formula in this cell if the displayed value is not one of my 18. Also, if I'm able to "white out" the cell described above, I need to "white out" the cell next to it at the same time (which has a different formula already in it). Can the formatting from the first cell be copied to the second cell if the conditions are met in the first cell? Help (and a BIG thank you!) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Thanks so much Earl!!! It worked perfectly!
"Earl Kiosterud" wrote: Trek, For this example the cells to change color will be B2 and C2, depending on the contents of B2. Make a list somewhere with your 18 values, and name it MyList. It can be in another sheet, and can be hidden (either the cells or the entire sheet). It could even be right in the definition of the named range, though that's not as good a way. Select B2 and C2. Format - Conditional formatting. Formula is: = OR($B2 = MyList) Click the Format button, Font tab, and select the white font color. OK OK again. Note that you can do this with multiple rows at once, but the formula above is for where the active (white) cell of your selection is in row 2. Change the $B2 term accordingly if necessary. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "trekguy1" wrote in message ... Hi, I'm trying to "white out" the text in a cell if a certain value is displayed (the cell has an existing formula in it already). What formula can I use in the conditional formatting window to white out multiple (about 18) specific values if they show up in the cell? And how do I maintain using my original formula in this cell if the displayed value is not one of my 18. Also, if I'm able to "white out" the cell described above, I need to "white out" the cell next to it at the same time (which has a different formula already in it). Can the formatting from the first cell be copied to the second cell if the conditions are met in the first cell? Help (and a BIG thank you!) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |