Conditional Formatting based on another cell

I have a simple CF to achieve but don't know how to achieve this.

I have a spreadsheet with times in it. Some times are in bold and some in italic. Whate determines whether it is bold or italic is the value of a separate cell e.g.


The font style in Cell B34 will depend upon the value in Cell B4. How do I set up the CF in Cell B34 to refelect this as Cell B34 has a formula in it not exclusively related to Cell B4?

Pl see the attached file.

In the attached file all values in cells A13:C27 are formulas, which themselves have a reference to all of the values in row 2 via a Hlook up table based on permutations.

What I want to achieve is for example C23 being bold (which it is but only because I have manually made it so) and the bold font in C23 being relevant to the value of cell C2. So if C2=GKS then Cell 23 is bold but if C2 was GKF then it would be italic.

Thanks

Pl see file

Ok you have answered something that I completely misunderstood and that is that the first cell in the CF dialogue box refers to cell value and formula. I always thought this meant the formula in the cell you are trying to format not the CF formula you need to CF that cell! Doh!

OK thanks for that.

What is the formula if there are multiple conditions e.g. C2="ABC" or "DEF" etc? I know how to write it if it was an IF formula but not sure in the Conditional Formatting dialogue box.

Thanks Pepe.