How to change a cell colour depending on the result?

's Computer Specifications

Hello,

I want to change a cell colour depending on a result.

For example:

If b1>c3 then the colour change to red if not stays in black.

Also I need that the cell continue with the current formula:

=SUMAR.SI(INDIRECTO("Diario!J"&Z53&":J"&AA53);$A$66;INDIRECTO("Diario!L"&Z53&":L"&AA53))

Thanks a lot.

's Computer Specifications

Look at Format=>conditional Formatting

--
Regards,
Tom Ogilvy

"Vokaj" wrote:

> Hello,
>
> I want to change a cell colour depending on a result.
>
> For example:
>
> If b1>c3 then the colour change to red if not stays in black.
>
> Also I need that the cell continue with the current formula:
>
> =SUMAR.SI(INDIRECTO("Diario!J"&Z53&":J"&AA53);$A$66;INDIRECTO("Diario!L"&Z53&":L"&AA53))
>
> Thanks a lot.
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Colour change depending on result	SimoninParis	Microsoft Excel Discussion	2	2nd Oct 2009 04:07 PM
Colour cell (or text) depending upon IF Function result	jamie.rowland@shell.com	Microsoft Excel Programming	4	25th Jul 2006 04:31 PM
Change colour of cell depending on content	blain	Microsoft Excel Programming	9	17th Jun 2006 01:47 PM
Re: Change colour of cell depending on content	Norman Jones	Microsoft Excel Programming	1	16th Jun 2006 10:23 AM
How can i change cell colour depending on month of date in cell?	andy75	Microsoft Excel Misc	2	6th Jan 2006 07:46 AM