Convert cell colours based on other cell values. - Microsoft Community

hi everyone,

back again in place know guaranteed me.

with table below, need cells in last column change colour if first column has word motor selected drop down. there way that? thinking of conditional formatting can make first column change colour when word motor inputted.

policy category	premium quoted	premium accepted	quote follow up	financial leads	cover confirmation
motor	£100.00	£100.00	na	mention
fleet	£5,000.00	£5,000.00	na	already us
commercial	£799.00	£799.00	na	no mention

select cells in final column and, in cond form dialog, use formula =$a2="motor"

the 'trick' lies in single $ in reference a2

best wishes

Office / Excel / Windows 10 / Office 365 for business