Hi everyone,
Can't seem to work this one out.
I've a 3 columns:
D8:D250
E8:E250
F8:F250
What I want to do is do some conditional formatting where each cell in the column F will change depending on the adjacent cell values in columns D&E.
For example:
If the adjacent cell in say D = "A" and the adjacent cell in E = "Y" then the value in the cell in E needs to be 100
If the adjacent cell in D = "B" and the adjacent cell in E = "Y" then the vale of the cell in E needs to be 50
Than I want to apply that to every cell in column F
Any ideas?
Thanks
Bookmarks