Adding colour to result in a cell?

If you are not into VBA coding the easiest way to do this is with conditional formatting.

Ed

Not with 5 values it's not.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"EdMac" <EdMac.224tez_1138094102.7414@excelforum-nospam.com> wrote in
message news:EdMac.224tez_1138094102.7414@excelforum-nospam.com...
>
> If you are not into VBA coding the easiest way to do this is with
> conditional formatting.
>
> Ed
>
>
> --
> EdMac
> ------------------------------------------------------------------------
> EdMac's Profile:
http://www.excelforum.com/member.php...o&userid=30736
> View this thread: http://www.excelforum.com/showthread...hreadid=504334
>

Agreed,Bob, but not clear exactly what is required.

Ed

Thanks for the replies Bob & Ed,

That first reply from you Bob nearly blew my mind...where on earth does that
lot go?

Conditional formatting sounds like it might be easier - if I were to reduce
the number of colours needed from 5 down to 3 or even 2 how would
conditional formatting work?

An example or two would be nice - please excuse my ignorance and bear with
me - I am a complete idiot when it comes to Excel (and many other things
besides! :-)

Thanks & regards,
-=pp=

I did explain at the end how to implement it. If you want CF

Select all the cells, starting at let's say A2

Menu Format>Conditional Formatting
Change Condition 1 to Formula Is
Add formula of =AND(E5="Y",E19=1)
Click Format
Select Pattern tab
Select red
OK

Click Add>>
Change Condition 1 to Formula Is
Add formula of =AND(E5="Y",E19=2)
Click Format
Select Pattern tab
Select green
OK

OK

obviously change the cells to suit.


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Pheasant PluckerŪ" <pheasant@plucker.not> wrote in message
news:OBzCkUPIGHA.3936@TK2MSFTNGP12.phx.gbl...
> Thanks for the replies Bob & Ed,
>
> That first reply from you Bob nearly blew my mind...where on earth does
that
> lot go?
>
> Conditional formatting sounds like it might be easier - if I were to
reduce
> the number of colours needed from 5 down to 3 or even 2 how would
> conditional formatting work?
>
> An example or two would be nice - please excuse my ignorance and bear with
> me - I am a complete idiot when it comes to Excel (and many other things
> besides! :-)
>
> Thanks & regards,
> -=pp=
>
>

Bob's reply required you to be able to use VBA - that is fairly advanced stuff.

With Conditional formatting (Format>conditional formatting), you can set the format according to what is in the cell OR what is in another cell in the same sheet.

So if you want the the drop down box to be Red if there is 'N0' in it
Condition1 Cell Value>Is equal to>="No"

Then select format and you gett he chance to select the coulour of the font, cell infill and border.

Then select 'ADD' and you get the chance to set another format - e.g. for Yes. Repeat the process.

You can use al the normal Excel rules like IF, AND etc to build up complicated setups.

Hope this helps

Ed