Cell Color Changes
 

I have a copy of spreadsheet that changes cell colors when I type in a
particular word. I would like to know what steps it takes to get that done.
Thanks for the help.

Cell Color Changes
 

You can use conditional formatting, but if you are using excel pre 2007
you only get to write 3 conditions, for a great explanation check out
Bob Phillips site http://www.xldynamic.com/source/xld.CF.html it doesn't
come better than that!

masweets;188277 Wrote:
I have a copy of spreadsheet that changes cell colors when I type in a
particular word. I would like to know what steps it takes to get that
done.
Thanks for the help.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51923

Cell Color Changes
 

That is conditional formatting you can remove it if not required. Conditional
formatting is done when there is a requirement of formatting the cells based
on certain conditions.
We can conditional formatt these cells for a maximum of three conditions.
--
_______________________
Click "Yes" button if it helps
________
Thanks
Suleman Peerzade


"masweets" wrote:

I have a copy of spreadsheet that changes cell colors when I type in a
particular word. I would like to know what steps it takes to get that done.
Thanks for the help.

Cell Color Changes
 

Thanks for the help! Bob Phillips response and yours were just what I needed
to complete the project!

Mike

"masweets" wrote:

I have a copy of spreadsheet that changes cell colors when I type in a
particular word. I would like to know what steps it takes to get that done.
Thanks for the help.