View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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.