software

eg. value 1 and 2 in a cell should make an entire row red

eg. value 3 to 6 in a cell should make an entire row blue

Ideally I want a formula when if I put 1 or 2 into a cell it highlights
the row as red

maybe I if I input a 3, 4, 5, 6 it highlights red

Any thoughts? Thanks in Advance.This can be done with conditional formatting.
lt;FORMATgt; - lt;CONDITIONAL FORMATTINGgt;
specify your criterium and set your format.

Successquot; wrote:

gt; eg. value 1 and 2 in a cell should make an entire row red
gt;
gt; eg. value 3 to 6 in a cell should make an entire row blue
gt;
gt; Ideally I want a formula when if I put 1 or 2 into a cell it highlights
gt; the row as red
gt;
gt; maybe I if I input a 3, 4, 5, 6 it highlights red
gt;
gt; Any thoughts? Thanks in Advance.
gt;
gt;


can we use conditional formatting to hightlight a whole row? I thought
it only hightlights the specific cell--
MC82
------------------------------------------------------------------------
MC82's Profile: www.excelforum.com/member.php...oamp;userid=18682
View this thread: www.excelforum.com/showthread...hreadid=502709Yes you can highlight an entire row.

Select the row(s) and Formatgt;CF Formula is:

=$A1=10

Note the $ sign which locks the column AGord Dibben MS Excel MVP

On Thu, 19 Jan 2006 13:48:45 -0600, MC82
gt; wrote:

gt;
gt;can we use conditional formatting to hightlight a whole row? I thought
gt;it only hightlights the specific cellI am trying to do something very similar, so this is v. interesting for me
too. Unfortunatley, Gord, I cannot workout what your advise means! Let me
advise my objective:

If the value of a cell in, say, column C is either quot;wonquot;, quot;lostquot; or
quot;outstandingquot;, then I want the respective row to be red, yellow or green.
e.g. c7=won, row7=red; c11=lost, row11=green

How do I amend your below advise?

Allan

quot;Gord Dibbenquot; wrote:

gt; Yes you can highlight an entire row.
gt;
gt; Select the row(s) and Formatgt;CF Formula is:
gt;
gt; =$A1=10
gt;
gt; Note the $ sign which locks the column A
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Thu, 19 Jan 2006 13:48:45 -0600, MC82
gt; gt; wrote:
gt;
gt; gt;
gt; gt;can we use conditional formatting to hightlight a whole row? I thought
gt; gt;it only hightlights the specific cell
gt;
gt;

I can sort of work it out - could one of you guys clarify this further
for people still stuck?