Conditional Formating in EXCEL

James240

Guys I need some help, I need to use conditional formatting on certain cells in Excel and im somewhat stuck though. I can use the Conditional Formating to shade out 1 cell by itself when a certain option is selected from a dropdown list in another cell that’s not a problem, the issue is that I want to grey out other cells as well at the same time but I don’t know how to include them include them in the Conditional Formatting. Any help would be great as I need this for work The current formula im using for the conditional formating is =IF(AND ( $B$36= " Insert Address " ) ,TRUE )
(Please ignore the spacing in the formula as the computer at work seems to be putting in smilies and quotes and not displaying it properly doh!) Thanks James

rmg1

You should be able to use the format painter to copy the conditional formatting to the other cells you need.
What version of Excel are you using?

_Andy_

You'd want the same conditional formatting formula in the other cells (unless I'm missing something)

LucianH

Just one observation, why are you using that formula when the following does just the same thing (you dont actually need the brackets:

=( $B$36= " Insert Address" )

And, as _Andy_ says, you just want to use the same formula with different formating for the other cells

James240

rmg1 wrote: »

You should be able to use the format painter to copy the conditional formatting to the other cells you need.
What version of Excel are you using?

OMG i totally forgot about format painter! Thanks for all your help guys much apprecaited