Highlight cells in a row with a given value
Hi,
Select ypu data then
Format|Conditional format
cell value is
Select 'less than'
enter 0 in the value box
Pick your colour
Click OK
Mike
"evoxfan" wrote:
I have a simple math formula (sum) in column adding values typed into
previous columns. I would like for any value less than 0 to be highlited in
yellow.
Any help is appreciated.
Thanks.
|