On 2002-10-15 08:59, inarbeth wrote:
On 2002-10-15 08:55, chad13 wrote:
How do I make a range bold (or change color) if the column heading meets certain criteria? Ex. If A10="YES", then I want the range A11:A20 to change to bold.
You can do this easily using conditional formatting. Select the range A11:A20 and select Format, Conditional Formatting. Choose Formula is and type: =$A$10="YES"
Select Format and apply the bold font.