Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting<?
Good Day,
Here is my example: A1 = Dog B1 = Gene A2 = Cat B2 = Karen I would like to Bold and Color "Dog" when B1 = Gene....but if B1 = Karen, do not Bold and Color. Can I do this will Conditional Formatting on Col A? MUCH THANKS! Gene:) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting<?
Select col A (A1 active), then apply CF using Formula is:
=AND(A1="dog",B1="Gene") Format to taste OK out -- Max Singapore http://savefile.com/projects/236895 Downloads:18,400 Files:361 Subscribers:58 xdemechanik --- "Gene" wrote: Good Day, Here is my example: A1 = Dog B1 = Gene A2 = Cat B2 = Karen I would like to Bold and Color "Dog" when B1 = Gene....but if B1 = Karen, do not Bold and Color. Can I do this will Conditional Formatting on Col A? MUCH THANKS! Gene:) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |