Excel - Conditional Formatting

Carrieann

Distinguished
Jul 7, 2011
1
0
18,510
0
Hello,
I have a spreadsheet with two columns and about 100 rows. Column A and B has all "yes" or "no" answers in it. I want a formula created that when the answer is "yes" in BOTH columns, the cells will highlight in yellow.
 

JordoR

Distinguished
Jan 10, 2010
33
0
18,590
1
No problem.. Follow these steps (Done in Office 2007, not sure which format you have)

- Select all cells in both columns
- Navigate to conditional formatting on the home tab
- Select highlight cells rule
- Select Equal to..
- In the first field put yes, and in the second field select yellow highlight
(You may have to go to custom highlight and then modify it yourself since it might not be a default setting in your ofice)

After that all your cells with YES in them will be highlighted in yellow.

If you have any troubles or any other questions, let me know.
 
Thread starter Similar threads Forum Replies Date
B Apps General Discussion 2
N Apps General Discussion 1
S Apps General Discussion 5
N Apps General Discussion 2
L Apps General Discussion 5
B Apps General Discussion 4
K Apps General Discussion 1
R Apps General Discussion 1
7 Apps General Discussion 37
J Apps General Discussion 11
E Apps General Discussion 15
L Apps General Discussion 5
S Apps General Discussion 1
A Apps General Discussion 1
E Apps General Discussion 1
T Apps General Discussion 1
B Apps General Discussion 1
B Apps General Discussion 23
Z Apps General Discussion 4
P Apps General Discussion 1

ASK THE COMMUNITY