Conditional Formatting

[ZacCerrato]

I would like to embolden one of several cells on a row based on the value of a particular cell.

For instance, if cell B2 has the value "Apples" I would like the contents of cell D2 emboldened. If cell B2 has the value "Bananas" I would like the contents of cell E2 emboldened. If cell B2 has the value "Grapes" I would like the contents of cell F2 emboldened.

What's the syntax for an If-function to do this? Thanks in advance for any help!

 

[Steve=True]

=IF(AND($B2="Apples",COLUMN()=4),TRUE,IF(AND($B2="Bananas",COLUMN()=5),TRUE,IF(AND($B2="Grapes",COLUMN()=6),TRUE,FALSE)))

Steve=True
www.exceldashboardtemplate.com