Conditional Formatting Excel 2007
Closed
Toya
-
Aug 31, 2012 at 10:27 AM
ExcelJosh
ExcelJosh
- Posts
- 12
- Registration date
- Wednesday August 8, 2012
- Status
- Contributor
- Last seen
- October 12, 2012
Related:
- Conditional Formatting Excel 2007
- Conditional formatting in excel 2007 ✓ - Forum - Excel
- How to use conditional formatting in Excel - Guide
- How to change the date format in Excel 2007 ✓ - Forum - Excel
- Cannot change the date format in Excel 2007 ✓ - Forum - Excel
- How do I use conditional formatting in Excel ✓ - Forum - Excel
1 reply
ExcelJosh
Sep 5, 2012 at 08:27 AM
- Posts
- 12
- Registration date
- Wednesday August 8, 2012
- Status
- Contributor
- Last seen
- October 12, 2012
Sep 5, 2012 at 08:27 AM
Toya:
Here is what I did when doing what you wanted. I created a data validation list in F3 of Yes or No. I then highlighted A35:D39. Clicked on the "Home" tab and selected Conditional Formatting and then "New Rule". Select "Use a formula to determine which cells to format". You can then type in "=$F$3="Yes"". Select "Format", then click the "Fill" tab, select yellow and then "ok". Now, go and change the list from yes to no and back and forth. Each time, you have to move out of that cell in order for the change to take effect.
I hope this helps.
If you want, you can use the "Record Macro" in the "Developer" tab to see the code that would be created with this process.
Good luck,
Josh
Here is what I did when doing what you wanted. I created a data validation list in F3 of Yes or No. I then highlighted A35:D39. Clicked on the "Home" tab and selected Conditional Formatting and then "New Rule". Select "Use a formula to determine which cells to format". You can then type in "=$F$3="Yes"". Select "Format", then click the "Fill" tab, select yellow and then "ok". Now, go and change the list from yes to no and back and forth. Each time, you have to move out of that cell in order for the change to take effect.
I hope this helps.
If you want, you can use the "Record Macro" in the "Developer" tab to see the code that would be created with this process.
Good luck,
Josh