Condition Formatting

Your formula is

Formula:

Please Login or Register  to view this content.

Excel looks at Yes and thinks it is a name, but no such name exists, so it returns an error. Errors in CF formulas are silent.

You just need to put quotes around it.

Formula:

Please Login or Register  to view this content.

Values as displayed

	A	B
3	Installation	Yes
4	Job Type
5	House type
6	Site access
Sheet1

Conditional Formatting Rules

Formula
Applies To	Formula	Format	Stop If True
$B$3:$B$6	=$B$3="Yes"		False
Sheet1

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.