Excel ~ Any Professionals Here ?

Kohaashi · 23 Jan 2008 at 21:21

Hi

Basically i'm trying to figure out the command for when i type a word e.g. Open, the colour in the background of the cell turns green, but also keeps the word (Open).

Is this possible?

I'm sure i'll have furture questions however I've solved most of the ones I was going to ask.

Any possitive replies are much appreciated.

Chadd

kibblerok · 23 Jan 2008 at 21:30

format > conditional formatting?

or have i misunderstood?

Kohaashi · 23 Jan 2008 at 21:44

kibblerok said:
format > conditional formatting?

or have i misunderstood?

That's it !

I worked it out now. Thanks for the hint

appreciated.

Kohaashi · 23 Jan 2008 at 21:54

Ok, another.. (if you please)
What's the formula so that when I type 'Closed' in a cell, everything on that words horizontal line gets a strikethrough ? :confused:

MarcLister · 23 Jan 2008 at 22:48

On that entire row? Still a conditional formatting formula. Slightly more complicated of course.

http://exceltips.vitalnews.com/Pages/T0793_Conditionally_Formatting_an_Entire_Row.html
http://sysdev.uncc.edu//HowTos/Excel/Using Conditional Formatting to Format Entire Rows in Excel.htm
http://j-walk.com/ss/excel/usertips/tip043.htm

etc from http://www.google.co.uk/search?clie...matting++row&sourceid=opera&ie=utf-8&oe=utf-8

Kohaashi · 23 Jan 2008 at 23:11

Thanks for the links but they don't really help me

I'll try explain a little better.
Say I have the word 'Closed' in cell A4, becuase I have that word in cell #4 I want all cells horizontal to that cell to be strikedthough.

I'll keep looking, but any additional help is really appreciated