Change Text Colour

[CT (Oxford, UK)]

Can anyone explain how to conditionally change the text colour in a
spreadsheet - for example show negative numbers in red and positive numbers
black ?
Many thanks.

 

[Kassie]

Select the cell.
Click on Format, Conditional formatting.
next to Cell Value is, click on the dropdown, and select Less than. In the
adjacent box insert a 0
click on Add
Select your font colour
Click on Add, change Between to greeater than, and repeat.
OK out

--
HTH

Kassie

Replace xxx with hotmail

 

[Francis]

one other way without conditional formatting
select the cells
right click and select Format Cells
in Number tab, select Number
choose the format you want from Negative numbers
OK out
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another