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