Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting
Hi I would like to make a range of cells within a column turn green when certain conditions are met. The user will enter "I or "M" in each cell. If certain cells contain I's and certain cells contain M's then all of these cells turn green. Grateful for any assisstance. -- ANDYPAND ------------------------------------------------------------------------ ANDYPAND's Profile: http://www.excelforum.com/member.php...o&userid=25351 View this thread: http://www.excelforum.com/showthread...hreadid=390141 |
#2
|
|||
|
|||
Use a different column to check whether the correct pattern of I:s and M:s
are entered. For example with 0 if it's correct and 1 otherwise. Then summarize that column and have the conditional formatting check if that sum is greater than zero. /Marcus "ANDYPAND" wrote: Hi I would like to make a range of cells within a column turn green when certain conditions are met. The user will enter "I or "M" in each cell. If certain cells contain I's and certain cells contain M's then all of these cells turn green. Grateful for any assisstance. -- ANDYPAND ------------------------------------------------------------------------ ANDYPAND's Profile: http://www.excelforum.com/member.php...o&userid=25351 View this thread: http://www.excelforum.com/showthread...hreadid=390141 |
#3
|
|||
|
|||
That is the method i have used. Basically it ends up with the desired total of the score in the column as 3. The problem is how do i make the whole range of cells in the column turn green as a result? Conditional formatting applies to the active cell- what would the formula be to apply it to several cells? I have never written excel functions before. Thanks -- ANDYPAND ------------------------------------------------------------------------ ANDYPAND's Profile: http://www.excelforum.com/member.php...o&userid=25351 View this thread: http://www.excelforum.com/showthread...hreadid=390141 |
#4
|
|||
|
|||
1. Select the cells you want to apply the formatting to.
2. Choose Format, Conditional Formatting 3. Select "Formula Is" in the first drop-down 4. Enter "=$A$1=1" as the formula (without quote marks), where $A$1 is your check-sum cell and 1 is the number for which the formatting should be applied. /Marcus "ANDYPAND" wrote: That is the method i have used. Basically it ends up with the desired total of the score in the column as 3. The problem is how do i make the whole range of cells in the column turn green as a result? Conditional formatting applies to the active cell- what would the formula be to apply it to several cells? I have never written excel functions before. Thanks -- ANDYPAND ------------------------------------------------------------------------ ANDYPAND's Profile: http://www.excelforum.com/member.php...o&userid=25351 View this thread: http://www.excelforum.com/showthread...hreadid=390141 |
#5
|
|||
|
|||
Could you give some test data and expected results??? -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=390141 |
#6
|
|||
|
|||
I want the formatting to work like this: If C79 = Y then the cells in E12:E66 turn green -- ANDYPAND ------------------------------------------------------------------------ ANDYPAND's Profile: http://www.excelforum.com/member.php...o&userid=25351 View this thread: http://www.excelforum.com/showthread...hreadid=390141 |
#7
|
|||
|
|||
Highlight cells E12:E66 then go to Format-Conditional Formatting then choose "Formula is" and write: =$C$79="Y" Then click the format button next to the sample text and choose Patterns and then whatever color you want (in this case, green) and click OK, and that should be it. Let me know if it works out. -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=390141 |
#8
|
|||
|
|||
Thanks Marcus and all - it works now. I think I must have tried all sorts of combinations apart from the actual one that works- til now :) -- ANDYPAND ------------------------------------------------------------------------ ANDYPAND's Profile: http://www.excelforum.com/member.php...o&userid=25351 View this thread: http://www.excelforum.com/showthread...hreadid=390141 |
#9
|
|||
|
|||
Glad to hear it! ANDYPAND Wrote: Thanks Marcus and all - it works now. I think I must have tried all sorts of combinations apart from the actual one that works- til now :) -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=390141 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |