Conditional Formatting

[vman92]

Can I use conditional formatting to make the text in a column be red and bold if the value of two other sets of columns is equal?
The only set of Ns I would want in Red & Bold are the last set when both column F & column G are N.

for instance:

10000 20000 495001 20000 40000 M M
10000 40000 495001 20000 40000 M N
12000 25000 495001 20000 40000 M M
12500 25000 495001 20000 40000 M M
15000 30000 495001 20000 40000 M M
15000 40000 495001 20000 40000 M N
20000 20000 495001 20000 40000 N M
20000 40000 495001 20000 40000 N N

 

[Von Pookie]

Select G1 and go to Format\Conditional formatting

Enter:

Formula Is: =AND($F1="N",$G1="N")

and select bold and red from the formatting options available, then click OK until you are out of the dialog.

Copy G1 then highlight the rest of your data in the columns. Right click, select Paste Special\Formats and click OK.

Using your sample data, the "N" in G8 should turn red.

 

[Dutchy]

Do I understand you correctly?

You want conditional formatting in column G only, to be activated when both G and F in that row are equal to "N"?

If you use the condition as follows:

=AND(F1="N",G1="N")

and copy down as necessary

That should do the trick

 

[vman92]

Thanks you both gave me some ideas. What I had wanted was to turn the last 2 columns red-text & bold if they were both equal to 'N'.

I used conditional formatting to set color to black and normal if the cell was equal to 'M' and as a second condition I set the color to red & bold if F=G then for column G - I reversed the equation. Works great thanks again.