Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column I:I blue
Hello from Steved
In Col A2 the number is 5543 In Col E2 the number is 5177 In Col I2 the Colour is Blue As col A2 number is different from Col E2 then Colour Col I5 blue yes if Cell A:A and Cell E:E have the same then ignore please. I have over 2,500 row2 so please what is required. I thankyou. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column I:I blue
Select column I, FormatConditional Formattingchoose Formula as condition,
enter =A1<E1 in criterium, choose blue patternOK Regards, Stefi €˛Steved€¯ ezt Ć*rta: Hello from Steved In Col A2 the number is 5543 In Col E2 the number is 5177 In Col I2 the Colour is Blue As col A2 number is different from Col E2 then Colour Col I5 blue yes if Cell A:A and Cell E:E have the same then ignore please. I have over 2,500 row2 so please what is required. I thankyou. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column I:I blue
Hello from Steved
Thankyou "Stefi" wrote: Select column I, FormatConditional Formattingchoose Formula as condition, enter =A1<E1 in criterium, choose blue patternOK Regards, Stefi €˛Steved€¯ ezt Ć*rta: Hello from Steved In Col A2 the number is 5543 In Col E2 the number is 5177 In Col I2 the Colour is Blue As col A2 number is different from Col E2 then Colour Col I5 blue yes if Cell A:A and Cell E:E have the same then ignore please. I have over 2,500 row2 so please what is required. I thankyou. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column I:I blue
You are welcome! Thanks for the feedback!
Stefi €˛Steved€¯ ezt Ć*rta: Hello from Steved Thankyou "Stefi" wrote: Select column I, FormatConditional Formattingchoose Formula as condition, enter =A1<E1 in criterium, choose blue patternOK Regards, Stefi €˛Steved€¯ ezt Ć*rta: Hello from Steved In Col A2 the number is 5543 In Col E2 the number is 5177 In Col I2 the Colour is Blue As col A2 number is different from Col E2 then Colour Col I5 blue yes if Cell A:A and Cell E:E have the same then ignore please. I have over 2,500 row2 so please what is required. I thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blue screen | New Users to Excel | |||
what do 'blue filenames' mean? | Excel Discussion (Misc queries) | |||
Filter Indicator on Column top should be white, not dark blue | Excel Worksheet Functions | |||
how do I sort a column with several categories (ie red and blue) | Excel Worksheet Functions |