 I have a sheet with 4 fields spanning
A3:D3
 in
D3
I have a conditional format that turns the cell yellow if it equals the word "no contact"
How can I get Cells A3:C3
to also turn yellow if this is the case, any help would be greatly appreciated
How can I get Cells 


This question came from our site for professional and enthusiast programmers.
Select the cells from A3 to D3 then click on the Conditional Formatting then on the New Rule... after that choose the option Use a formula to determine which cells to format and then write the following as the rule After that you can click on Conditional Formatting and then on Manage Rules... to see your rule. Hope it helps. 


In your Conditional Formatting edit the



You can use the Format Painter, unless you have further rules in Select 

