# Conditional Formatting

#### vman92

##### New Member
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

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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.

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

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.

Replies
1
Views
398
Replies
10
Views
566
Replies
3
Views
278
Replies
0
Views
159
Replies
0
Views
348

1,207,107
Messages
6,076,586
Members
446,215
Latest member
userds5593

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back