Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Confusion...(conditional formatting)
Thanks to all that replied to my post!! I was looking to make F2 field a required field, i.e <red If E2 = "yes" then make F2 a required field. I am going to email this spreadsheet to users, if the user select "yes" to question asked in E column, I would like them to provide detailed information in column F. Does that make sense? Thank you again for your help! this forum rocks! -- nishapurohit ------------------------------------------------------------------------ nishapurohit's Profile: http://www.excelforum.com/member.php...o&userid=30983 View this thread: http://www.excelforum.com/showthread...hreadid=506552 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Confusion...(conditional formatting)
Sure. Click on F2. Format--Conditional Formatting, Formula is:
=IF(E2)="yes" Tell it to be red fill.... ************ Hope it helps! Anne Troy www.OfficeArticles.com "nishapurohit" wrote in message news:nishapurohit.22gw4y_1138657504.0146@excelforu m-nospam.com... Thanks to all that replied to my post!! I was looking to make F2 field a required field, i.e <red If E2 = "yes" then make F2 a required field. I am going to email this spreadsheet to users, if the user select "yes" to question asked in E column, I would like them to provide detailed information in column F. Does that make sense? Thank you again for your help! this forum rocks! -- nishapurohit ------------------------------------------------------------------------ nishapurohit's Profile: http://www.excelforum.com/member.php...o&userid=30983 View this thread: http://www.excelforum.com/showthread...hreadid=506552 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Confusion...(conditional formatting)
No need for the IF, just use
=E2="yes" as that resolves to TRUE or FALSE -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Anne Troy" wrote in message ... Sure. Click on F2. Format--Conditional Formatting, Formula is: =IF(E2)="yes" Tell it to be red fill.... ************ Hope it helps! Anne Troy www.OfficeArticles.com "nishapurohit" wrote in message news:nishapurohit.22gw4y_1138657504.0146@excelforu m-nospam.com... Thanks to all that replied to my post!! I was looking to make F2 field a required field, i.e <red If E2 = "yes" then make F2 a required field. I am going to email this spreadsheet to users, if the user select "yes" to question asked in E column, I would like them to provide detailed information in column F. Does that make sense? Thank you again for your help! this forum rocks! -- nishapurohit ------------------------------------------------------------------------ nishapurohit's Profile: http://www.excelforum.com/member.php...o&userid=30983 View this thread: http://www.excelforum.com/showthread...hreadid=506552 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Confusion...(conditional formatting)
Thanks, Bob. :)
************ Hope it helps! Anne Troy www.OfficeArticles.com "Bob Phillips" wrote in message ... No need for the IF, just use =E2="yes" as that resolves to TRUE or FALSE -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Anne Troy" wrote in message ... Sure. Click on F2. Format--Conditional Formatting, Formula is: =IF(E2)="yes" Tell it to be red fill.... ************ Hope it helps! Anne Troy www.OfficeArticles.com "nishapurohit" wrote in message news:nishapurohit.22gw4y_1138657504.0146@excelforu m-nospam.com... Thanks to all that replied to my post!! I was looking to make F2 field a required field, i.e <red If E2 = "yes" then make F2 a required field. I am going to email this spreadsheet to users, if the user select "yes" to question asked in E column, I would like them to provide detailed information in column F. Does that make sense? Thank you again for your help! this forum rocks! -- nishapurohit ------------------------------------------------------------------------ nishapurohit's Profile: http://www.excelforum.com/member.php...o&userid=30983 View this thread: http://www.excelforum.com/showthread...hreadid=506552 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Confusion...(conditional formatting)
You know the pleasure is mine Ma'am,
Bob "Anne Troy" wrote in message ... Thanks, Bob. :) ************ Hope it helps! Anne Troy www.OfficeArticles.com "Bob Phillips" wrote in message ... No need for the IF, just use =E2="yes" as that resolves to TRUE or FALSE -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Anne Troy" wrote in message ... Sure. Click on F2. Format--Conditional Formatting, Formula is: =IF(E2)="yes" Tell it to be red fill.... ************ Hope it helps! Anne Troy www.OfficeArticles.com "nishapurohit" wrote in message news:nishapurohit.22gw4y_1138657504.0146@excelforu m-nospam.com... Thanks to all that replied to my post!! I was looking to make F2 field a required field, i.e <red If E2 = "yes" then make F2 a required field. I am going to email this spreadsheet to users, if the user select "yes" to question asked in E column, I would like them to provide detailed information in column F. Does that make sense? Thank you again for your help! this forum rocks! -- nishapurohit ------------------------------------------------------------------------ nishapurohit's Profile: http://www.excelforum.com/member.php...o&userid=30983 View this thread: http://www.excelforum.com/showthread...hreadid=506552 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |