Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating based on a different cell
Hi! I have two cells : A1 and E1. If I type any stock symbol into A1, I like
to change the text color in E1. -- Many thanks for your help in advance. Have a wonderful day! Zsolt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating based on a different cell
in E1, use the formula form of the Conditional Format
=if(A1...,True,False) The format you require will be set if the result is True This can be reduced to =(A1=...), but it's still basically an IF() Steve On Sat, 09 Dec 2006 20:42:01 -0000, Zsolt Szabó wrote: Hi! I have two cells : A1 and E1. If I type any stock symbol into A1, I like to change the text color in E1. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating based on a different cell
You can format E1 based on content of A1
Select E1 and FormatCFFormula is =A1="text" But.....you say "any symbol" How will Excel know what is a symbol? Maybe any text that is not a number? CFFormula is: =NOT(ISNUMBER(A1)) Gord Dibben MS Excel MVP On Sat, 9 Dec 2006 12:42:01 -0800, Zsolt Szabó wrote: Hi! I have two cells : A1 and E1. If I type any stock symbol into A1, I like to change the text color in E1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Significant number rounding based on key cell | Excel Worksheet Functions | |||
CONDITIONAL FORMATTING BASED ON RESULTS IN A CELL | Excel Worksheet Functions | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Conditional Formating a cell .. to Show Nothing .. if True | Excel Worksheet Functions | |||
Conditional formating -identify blank cell | Excel Worksheet Functions |