software

Hi there,

Basically i want cell F6 to change colour if cell F5 reads quot;Failedquot;. I
can't seem to get the formula right!

I don't know if it makes a difference but in cell F5 i have used the
Validation function with a list of 2 options: Failed and successfull.

Any help would be greatly received, cheers

James
James,

In F6 the CF should be.

Formula is: =F5=quot;Failedquot;

Click on format to apply the fill you want. Click OK, OK. It should
not matter that F5 contains a Data Validation list.

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=510640Cheers Steve,

Works a treat mate.

quot;Shaggyjhquot; wrote:

gt; Hi there,
gt;
gt; Basically i want cell F6 to change colour if cell F5 reads quot;Failedquot;. I
gt; can't seem to get the formula right!
gt;
gt; I don't know if it makes a difference but in cell F5 i have used the
gt; Validation function with a list of 2 options: Failed and successfull.
gt;
gt; Any help would be greatly received, cheers
gt;
gt; James
gt;

Next problem is that i would like the formatting to disappear when a value is
entered into the F6 cell.

So i assume i have to enter a Condition 2, and that it will have to be an
quot;Andquot; formula to have the F5=quot;Failedquot; in as well as a part that changes the
formatting when a value is entered into F6.

Does that make sense? Hopefully!

Cheers
James
quot;SteveGquot; wrote:

gt;
gt; James,
gt;
gt; In F6 the CF should be.
gt;
gt; Formula is: =F5=quot;Failedquot;
gt;
gt; Click on format to apply the fill you want. Click OK, OK. It should
gt; not matter that F5 contains a Data Validation list.
gt;
gt; HTH
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=510640
gt;
gt;


If you want the format to be different then you do need to add a second
condition. If your formatting is going to be the same if the value
appears then,

=OR(F5=quot;Failedquot;,F5=YourValue)
Does that help?

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=510640That doesn't help really.

Basically i have 'condition 1' changing the colour in cell F6 if cell E6 has
quot;Failedquot; in it. Which works fine. I then want cell F6 to change to a
different colour if i write anything in cell F6, regardless of whether E6
still says quot;Failedquot; or not.

Hope that makes more sense.

Jamesquot;SteveGquot; wrote:

gt;
gt; If you want the format to be different then you do need to add a second
gt; condition. If your formatting is going to be the same if the value
gt; appears then,
gt;
gt; =OR(F5=quot;Failedquot;,F5=YourValue)
gt;
gt;
gt;
gt; Does that help?
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=510640
gt;
gt;


James,

I think I got it now.

In F6 your 1st condition should be:

Formula is: =F6lt;gt;quot;quot; then format how you need

Condition 2

Formula is: =E6=quot;Failedquot; then format how you need.

Conditional formatting looks at your conditions in order so if the
first condition is true it will apply that even if your other
conditions are met. By putting the evaluation of cell F6 first,
anytime it contains a value, it will turn to that format but if not it
steps down to condition 2.

Does that help?

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=510640Yeah that works fine. I actually tried it just before i got your post. Many
thanks for all your help Steve.

Jamesquot;SteveGquot; wrote:

gt;
gt; James,
gt;
gt; I think I got it now.
gt;
gt; In F6 your 1st condition should be:
gt;
gt; Formula is: =F6lt;gt;quot;quot; then format how you need
gt;
gt; Condition 2
gt;
gt; Formula is: =E6=quot;Failedquot; then format how you need.
gt;
gt; Conditional formatting looks at your conditions in order so if the
gt; first condition is true it will apply that even if your other
gt; conditions are met. By putting the evaluation of cell F6 first,
gt; anytime it contains a value, it will turn to that format but if not it
gt; steps down to condition 2.
gt;
gt; Does that help?
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=510640
gt;
gt;