Conditional formatting on Excel

Question

I'm making a schedule in excel and need some help with conditional formatting.

I'd like to make it so when people put there names in the orange area the box will turn either green or red depending on whether there name is on the list (in column J) Could someone tell me how I might go about doing this?

enter image description here

What version of excel are you using?

Marc K
– Marc K

2015-06-22 17:40:15 +00:00
Commented Jun 22, 2015 at 17:40 — Marc K
– Marc K, Commented Jun 22, 2015 at 17:40
The latest version (2013).

Ben Emmons
– Ben Emmons

2015-06-22 17:45:03 +00:00
Commented Jun 22, 2015 at 17:45 — Ben Emmons
– Ben Emmons, Commented Jun 22, 2015 at 17:45

kelvin 004 · Accepted Answer · 2015-06-29 07:13:13Z

1

Select range $C$3:$H$16

In New Formatting Rule dialog box, choose "use formula to determine which cells to format"

To get green cell, type the following and set fill format to green: =COUNTIF($J$3:$J$9,C3)

To get red cell, type the following and set fill format to red: =AND(C3<>"",COUNTIF($J$3:$J$9,C3)<1)

answered Jun 29, 2015 at 7:13

kelvin 004

4232 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Conditional formatting on Excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related