Conditional Formatting

[wmswat]

Im trying to teach myself the more complex side of excel by making an attendance sheet for my job.
But am stuck on this.

So how do a make the cells that contain either PN or PM green
and those containing XN or XM red?

 

[myith29]

Im trying to teach myself the more complex side of excel by making an attendance sheet for my job.
But am stuck on this.

So how do a make the cells that contain either PN or PM green
and those containing XN or XM red?

Hello wmswat,

What you need to do is highlight the column that the data will be in. From there you can click the Conditional Formatting drop-down icon on the Home tab. Click New Rule.

The Rule type you will want to utilize "Format Only Cells That Contain". From there you can tell it to Format Only Cells With: Specific Text containing "PN" (for example) with the Format color of green.

Once you do that you can just add a different Conditional Formatting for each of the other cells you wont too.

Let me know if this helps!

 

[jim may]

Select area to be Formatted; Example A1:A10

In Formula Box enter:

=OR(A1="PN",A1="PM") Format Green

Re-enter Screen to ADD: New Rule of:

=OR(A1="XN",A1="XM") Format Red

 

[wmswat]

Hello wmswat,

What you need to do is highlight the column that the data will be in. From there you can click the Conditional Formatting drop-down icon on the Home tab. Click New Rule.

The Rule type you will want to utilize "Format Only Cells That Contain". From there you can tell it to Format Only Cells With: Specific Text containing "PN" (for example) with the Format color of green.

Once you do that you can just add a different Conditional Formatting for each of the other cells you wont too.

Let me know if this helps!

Thanks so much. I figured it out. I was close before but I had to go to the classic tab to find "Format Only Cells That Contain"

Thanks so much