Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hjm - 24 Nov 2006 11:24 GMT

Hi,

I need to add in the following conditional formats and was wondering if
anyone can help.

If L1 is not equal to N1 the colour row Yellow
If L1 is equal to N1 & O1 equals A, colour row Green
If L1 is equal to N1 & O1 equals B, colour row Orange
If L1 is equal to N1 & O1 equals C, colour row Red

Can anyone help please?

Many Thanks

Reply to this Message

Roger Govier - 24 Nov 2006 11:44 GMT

Hi

Conditional Formatting only support 3 conditions ( or 4 if you consider
the standard default format e.g Black on white as a condition)
Provided you treat your Yellow as standard format and not coloured at
all, then you can use
Format>Conditional Formatting>select dropdown for Formula Is
=AND(L1=N1,O1="A")
Format Green

Repeat changing A for B and C and Colours for Orange and Red for the
other two conditions.

Bob Phillips has an Add in to use more formats at his site
http://xldynamic.com/source/xld.CFPlus.Download.html

Signature

Regards

Roger Govier

> Hi,
>
[quoted text clipped - 10 lines]
>
> Many Thanks

Reply to this Message