Highlight cells in column A

[rcirone]

Highlight cells in column A Green if on the same row in column G is Yes

this is what I tried [=VLOOKUP(A2,A:G,7,0)="yes"] what am I doing wrong

 

[dreid1011]

Perhaps this:

Book1
	A	B	C	D	E	F	G
1							Yes
2							No
3							Yes
4							Yes
5							No
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A5	Expression	=$G1="Yes"	text	NO

 

[rcirone]

Perhaps this:

Book1
	A	B	C	D	E	F	G
1							Yes
2							No
3							Yes
4							Yes
5							No
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A5	Expression	=$G1="Yes"	text	NO

How do I add that to Condition formatting

 

[dreid1011]

How do I add that to Condition formatting

Select the cells you want the CF rule to apply to, column A in this case. Select Conditional Formatting on the ribbon:

Select "Use a formula to determine which cells to format" and enter the formula I provided in the box. (I must note that if your data starts in A2, then the formula should be =$G2="Yes"). Then select the desired formatting.

 

[rcirone]

This is what I can not get to work. Please Help
[=$A1="MM/DD/YYYY"]

 

[Joe4]

This is what I can not get to work. Please Help
[=$A1="MM/DD/YYYY"]

What are you trying to check with that?

That is checking to see if the literal text of "MM/DD/YYYY" appears in cell A1.

 

[rcirone]

What are you trying to check with that?

That is checking to see if the literal text of "MM/DD/YYYY" appears in cell A1

 

[rcirone]

I like to highlight cells RED in column A if cell in Column B same row have a date in them

 

[Joe4]

In Excel, dates are really just numbers with date formats applied to them.
Specifically, it is the number of days since 1/0/1900 (change the format of any cell with a date in it to General, and you will be able to see the date as Excel does).
Time is just the fractional piece of one day (i.e. 12 Noon would be 0.5).

Since dates are just numbers, you can use the formula:

=ISNUMBER($A1)

to check for a numeric entry in cell A1.

 

[rcirone]

In Excel, dates are really just numbers with date formats applied to them.
Specifically, it is the number of days since 1/0/1900 (change the format of any cell with a date in it to General, and you will be able to see the date as Excel does).
Time is just the fractional piece of one day (i.e. 12 Noon would be 0.5).

Since dates are just numbers, you can use the formula:

=ISNUMBER($A1)

to check for a numeric entry in cell A1.

Thank you