Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |