help please

A

amanda

help excel IF c3 has the word arrived make c1 & c2 to fill in colour i need
help in cell 3j i have the word yes in a1 & I have a name I want the name
cell to fill in a colour if 3j says yes
 
G

Gord Dibben

See help on Conditional Formatting.

Select C1 and C2

In Conditional Formatting>Formula is:

=C3="arrived"

Assuming "name cell" is G1

In G1 CF>Formula is:

=AND(A1="yes",J3="yes")


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about conditional formatting of zeros in Excel 0
Data Validation/Conditional Formating 3
How to determine the value - 15 Dec? 4
Conditional formatting - with 2 conditions 2
Excel Excel 2013 conditional formatting 1
Data Validation - Cell Colour 3
Conditionl format a cell to change text colour 5
Precedent Cell 1

Top