Change cell colours based on value.

[videsh77]

I have some calculation, if number after calculation comes less than 0, then cell background should automatically change to Red.

Can someone guide me, how this can be achieved? Thanks in advance.

 

[GlennUK]

Have a look at Conditional Formatting.

 

[DominicB]

Good morning videsh77

Select the required cell.
Format > Conditional Formatting

Cell value is
less than
0

and set your colour.

HTH

DominicB

 

[videsh77]

Thanks it helps.