If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting Formula
After some help with Conditional Formatting.
As an example I have the following data in cells B1 & B2; Cell B1 "Project 1 - Testing" Cell B2 "Project 2 - Not Issued" I want the cells containing the words "Not Issued" to be shaded (Green). In this example that would be "B2". Also I would like the same shading applied to cells A2, C2 to H2. Thanks |
#2
|
|||
|
|||
Conditional Formatting Formula
hi
while holding the Ctrl key down...with the mouse...select A2,C2 and H2. on the menu barformatconditional format Formula is.......=$B2="Not Issued"......pick your shade of green. ok out. the key is the dollar sign($). this points all selected cells in the row at column B but not the row so that you can copy A2:H2 and copy down as far as needed. regards FSt1 "Missile" wrote: After some help with Conditional Formatting. As an example I have the following data in cells B1 & B2; Cell B1 "Project 1 - Testing" Cell B2 "Project 2 - Not Issued" I want the cells containing the words "Not Issued" to be shaded (Green). In this example that would be "B2". Also I would like the same shading applied to cells A2, C2 to H2. Thanks |
#3
|
|||
|
|||
Conditional Formatting Formula
Select the cells you want to check for Not Issued. Say B1:B5
In Format Conditional formatting Formula Is =COUNTIF(B1,"*Not Issued*")0 Format Patterns click on green OK out. So now if you select B5 and note the conditional formatting in it, you will see the formula refers to B5 in that cell. Is not case sentive. Here is the formula again if perhaps the 's got you confused in my instructions. =COUNTIF(B1,"*Not Issued*")0 HTH Regards, Howard "Missile" wrote in message ... After some help with Conditional Formatting. As an example I have the following data in cells B1 & B2; Cell B1 "Project 1 - Testing" Cell B2 "Project 2 - Not Issued" I want the cells containing the words "Not Issued" to be shaded (Green). In this example that would be "B2". Also I would like the same shading applied to cells A2, C2 to H2. Thanks |
#4
|
|||
|
|||
Conditional Formatting Formula
Hi FSt1,
Just to note, the OP says the cells will contain something like "Project 1 - Not Issued". So =$B2="Not Issued" will not work if other characters are in the cell. =COUNTIF(B1,"*Not Issued*")0 looks for the occurrence of Not Issued among all the characters in the cell. Regards, Howard "FSt1" wrote in message ... hi while holding the Ctrl key down...with the mouse...select A2,C2 and H2. on the menu barformatconditional format Formula is.......=$B2="Not Issued"......pick your shade of green. ok out. the key is the dollar sign($). this points all selected cells in the row at column B but not the row so that you can copy A2:H2 and copy down as far as needed. regards FSt1 "Missile" wrote: After some help with Conditional Formatting. As an example I have the following data in cells B1 & B2; Cell B1 "Project 1 - Testing" Cell B2 "Project 2 - Not Issued" I want the cells containing the words "Not Issued" to be shaded (Green). In this example that would be "B2". Also I would like the same shading applied to cells A2, C2 to H2. Thanks |
#5
|
|||
|
|||
Conditional Formatting Formula
Excellent, thanks for that, modified it slightly and it works perfectly.
Added $ to the B1, eg. =COUNTIF($B1,"*Not Issued*")0 "L. Howard Kittle" wrote: Select the cells you want to check for Not Issued. Say B1:B5 In Format Conditional formatting Formula Is =COUNTIF(B1,"*Not Issued*")0 Format Patterns click on green OK out. So now if you select B5 and note the conditional formatting in it, you will see the formula refers to B5 in that cell. Is not case sentive. Here is the formula again if perhaps the 's got you confused in my instructions. =COUNTIF(B1,"*Not Issued*")0 HTH Regards, Howard "Missile" wrote in message ... After some help with Conditional Formatting. As an example I have the following data in cells B1 & B2; Cell B1 "Project 1 - Testing" Cell B2 "Project 2 - Not Issued" I want the cells containing the words "Not Issued" to be shaded (Green). In this example that would be "B2". Also I would like the same shading applied to cells A2, C2 to H2. Thanks . |
#6
|
|||
|
|||
Conditional Formatting Formula
You are welcome, thanks for the feedback.
Howard "Missile" wrote in message ... After some help with Conditional Formatting. As an example I have the following data in cells B1 & B2; Cell B1 "Project 1 - Testing" Cell B2 "Project 2 - Not Issued" I want the cells containing the words "Not Issued" to be shaded (Green). In this example that would be "B2". Also I would like the same shading applied to cells A2, C2 to H2. Thanks |
#7
|
|||
|
|||
Conditional Formatting Formula
hi
and you are right. i didn't read close enough or read too quickly or something. thanks for the correction. regards FSt1 "L. Howard Kittle" wrote: Hi FSt1, Just to note, the OP says the cells will contain something like "Project 1 - Not Issued". So =$B2="Not Issued" will not work if other characters are in the cell. =COUNTIF(B1,"*Not Issued*")0 looks for the occurrence of Not Issued among all the characters in the cell. Regards, Howard "FSt1" wrote in message ... hi while holding the Ctrl key down...with the mouse...select A2,C2 and H2. on the menu barformatconditional format Formula is.......=$B2="Not Issued"......pick your shade of green. ok out. the key is the dollar sign($). this points all selected cells in the row at column B but not the row so that you can copy A2:H2 and copy down as far as needed. regards FSt1 "Missile" wrote: After some help with Conditional Formatting. As an example I have the following data in cells B1 & B2; Cell B1 "Project 1 - Testing" Cell B2 "Project 2 - Not Issued" I want the cells containing the words "Not Issued" to be shaded (Green). In this example that would be "B2". Also I would like the same shading applied to cells A2, C2 to H2. Thanks . |
Thread Tools | |
Display Modes | |
|
|