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:) |
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:) |
All times are GMT +1. The time now is 08:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com