R
roxiemayfield
How do I have the cell turn gray if the sum is less than 0
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
FSt1
hi,
use conditional formating.
on the tool bar....Format>conditional formatihng
enter this.....if cell value is......less than.......0
format to gray.
regards
FSt1
use conditional formating.
on the tool bar....Format>conditional formatihng
enter this.....if cell value is......less than.......0
format to gray.
regards
FSt1
R
roxiemayfield
roxiemayfield said:How do I have the cell turn gray if the sum is less than 0
Thank you so Much! That is exactly what I needed.
P
Prasadkakarla
Hi FSt1,
if u want the particular value in a colour we have very good option in our
MS office Excel - in the Format menu > Condition format with the help of
this menu we can format condition wise.
u can use this
FOMAT > CONDITION FORMAT > Give the condition Cell value is Less then zero
,
u can make the format what color u want e.g grey. if u want u can bold
the text also , border also, then ok.
u will get the less then zero all in grey color.
Thanking you
--
Name : K.Prasad
Inventory Controller
CRYSTALGALLERY
DUBAI
if u want the particular value in a colour we have very good option in our
MS office Excel - in the Format menu > Condition format with the help of
this menu we can format condition wise.
u can use this
FOMAT > CONDITION FORMAT > Give the condition Cell value is Less then zero
,
u can make the format what color u want e.g grey. if u want u can bold
the text also , border also, then ok.
u will get the less then zero all in grey color.
Thanking you
--
Name : K.Prasad
Inventory Controller
CRYSTALGALLERY
DUBAI