Conditional Formatting

[Guest]

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

 

[Roger Govier]

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