Forum Home
Press F1
 
Thread ID: 88413 2008-03-26 20:50:00 XL B.M. (505) Press F1
Post ID Timestamp Content User
653007 2008-03-26 20:50:00 Dahhh, sorry guy's not thinking this morning.

I wish to conditional format cells in a column to red if they start with – (minus) sign or are negative. (In the red)

The range is D4-D800.

Nothing I’ve come up with so far is acceptable to XL. :crying
B.M. (505)
653008 2008-03-26 21:26:00 Have you looked at this (pressf1.pcworld.co.nz) Morgenmuffel (187)
653009 2008-03-26 22:12:00 The old brain coming on line late today.

Simply if cell number is less than zero.

No formula required. :(
B.M. (505)
1