Cell Color Changes

M

masweets

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.
 
S

Simon Lloyd

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

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

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
S

Suleman Peerzade

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
 
M

masweets

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

Mike
 
Top