Formatting Cells From Another Cell

[JonesZoid]

Hi All, I have Column I, which has a drop down menu in it, which if "WITH NOU" is selected - i would like it to change the colour of the text in column B, to a dark blue?

Any ideas....

JonesZoid

[Richard Buttrey]

Hi

Have you tried conditional formatting and used the 'formula is' option, referring back to the cell linked to your drop down menu?

Rgds

[JonesZoid]

I've tried it - but just cant work out how to do it....

[Richard Buttrey]

I've tried it - but just cant work out how to do it....

Hi,

Upload just the relevant bit of your workbook if the book is a large one and 'll take a look.

Rgds

[JonesZoid]

I've uploaded a spreadsheet - which is the one i actually use, but i've deleted a number of sheets with sensitive material on.
You'll see Column I with the drop down menu - Column B has the Site name (which i would like to format to a dark blue when column I shows "WITH NOU")

[VBA Noob]

Select Cols A to N then format > conditional formating > formula

=$I2="WITH NOU"

VBA Noob

[JonesZoid]

That didn't work - it just formatted the blank cells....Sorry

[JonesZoid]

Sorry - Tried it again, and it applied the format to the row above? Strange....

[JonesZoid]

Change $I2 to $I1 and it works fine now....Thanx

[Richard Buttrey]

Hi,

See attached. I've conditionally formatted B265 as an example.

HTH