Conditional Formatting Basics
I have Excel 2007 and for some reason I can't get started on Conditional
Formatting. For instance, I just want to highlight any cells that contain values the appear in other cells. I assumed this was "highlight duplicate cells" but I can't find where to plug in the range or tell Excel what columns to search. I'd like to ask if anyone can tell me how to make the above formatting happen. Thanks! I really appreciate it. |
Conditional Formatting Basics
You can use a formula. If you want to highlight B1 if it contains a value
that appears in C15, use the formula =B1=C15. B1 will have to be exactly equal to C15. If it is, the formula returns TRUE else FALSE. Then select the formatting you want. Tyro "David in VB" wrote in message ... I have Excel 2007 and for some reason I can't get started on Conditional Formatting. For instance, I just want to highlight any cells that contain values the appear in other cells. I assumed this was "highlight duplicate cells" but I can't find where to plug in the range or tell Excel what columns to search. I'd like to ask if anyone can tell me how to make the above formatting happen. Thanks! I really appreciate it. |
Conditional Formatting Basics
You'd want to make it: =B1=$C$15 so that you can copy the format over to any other cell (say in column B) to compare to that number. On Feb 4, 12:28 pm, "Tyro" wrote: You can use a formula. If you want to highlight B1 if it contains a value that appears in C15, use the formula =B1=C15. B1 will have to be exactly equal to C15. If it is, the formula returns TRUE else FALSE. Then select the formatting you want. Tyro "David in VB" wrote in ... I have Excel 2007 and for some reason I can't get started on Conditional Formatting. For instance, I just want to highlight any cells that contain values the appear in other cells. I assumed this was "highlight duplicate cells" but I can't find where to plug in the range or tell Excel what columns to search. I'd like to ask if anyone can tell me how to make the above formatting happen. Thanks! I really appreciate it. |
Conditional Formatting Basics
I would be very careful about copying conditional formatting in Excel 2007.
The conditional formatting does not replace conditional formatting in the cell to which it is copied, it augments any conditional formatting in that cell and becomes first in the rules list. Tyro "iliace" wrote in message ... You'd want to make it: =B1=$C$15 so that you can copy the format over to any other cell (say in column B) to compare to that number. On Feb 4, 12:28 pm, "Tyro" wrote: You can use a formula. If you want to highlight B1 if it contains a value that appears in C15, use the formula =B1=C15. B1 will have to be exactly equal to C15. If it is, the formula returns TRUE else FALSE. Then select the formatting you want. Tyro "David in VB" wrote in ... I have Excel 2007 and for some reason I can't get started on Conditional Formatting. For instance, I just want to highlight any cells that contain values the appear in other cells. I assumed this was "highlight duplicate cells" but I can't find where to plug in the range or tell Excel what columns to search. I'd like to ask if anyone can tell me how to make the above formatting happen. Thanks! I really appreciate it. |
All times are GMT +1. The time now is 12:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com