Conditional Formatting
 

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

Conditional Formatting
 

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
FormatConditional Formattingselect 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

--
Regards

Roger Govier


"hjm" wrote in message
...
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