Using a function result in one cell to change a format in another cell

[Guest]

I am trying to use a function result (ie: if a result of one cell = whatever), then the font color in a different cell & a different sheet should change to another color.

 

[Frank Kabel]

Hi Andrew
one way:
1. Select the cell which you want to check (lets say cell A1 on sheet
1)
2. Define a name for this Cell (goto 'Insert - Name - Define'). e.g.
define the name 'Conditional_Check'
3. Select the cell for which you want the color to change based on the
first cell's result
4. Goto 'Format - Conditional Format' and enter the following formula:
=Conditional_Check=value
5. Define your format for this value

you have to use the name definition as Excel's conditional format does
not accepts references to other worksheets.

HTH
Frank

 

[Bob Phillips]

Andrew,

You cannot do that directly, a function can only return a result to the cell
it is called from.

you could either use event code to set that format, or maybe even use
conditional formatting. Give more details and we can be more specific.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I am trying to use a function result (ie: if a result of one cell =

whatever), then the font color in a different cell & a different sheet
should change to another color.

 

[Guest]

Thanks Frank - works perfectly

 

[Frank Kabel]

Hi Andrew
you're welcome