How to change a cell colour depending on the result?

  • Thread starter Thread starter Vokaj
  • Start date Start date
V

Vokaj

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re. Conditional formating of adjacent cells but down a column 0
Need help with formulas over different sheets 4
Cell colour format according to date 1
Changing font colour for cell variables 3
Setting conditional colours for cells 2
Colour format code 2
formula to change font colour depending on which cell it has used 1
Create list depending on inserted value in a cell 1

Back
Top