How to change a cell colour depending on the result?
 

Hello,

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

For example:

If b1c3 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$6 6;INDIRECTO("Diario!L"&Z53&":L"&AA53))

Thanks a lot.

How to change a cell colour depending on the result?
 

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 b1c3 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$6 6;INDIRECTO("Diario!L"&Z53&":L"&AA53))

Thanks a lot.