Colour cells of specific value?

Posted to microsoft.public.excel.misc

external usenet poster

Posts: 2

Colour cells of specific value?

Hi all,

I want a macro that checks through the current worksheet and colours
every cell that has a specified value.. Eg. if F12 has "BAD" typed in
it, then F12 should be coloured red..

thanks in advance..

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
adding specific cells	Shooter	Excel Worksheet Functions	1	January 23rd 06 04:42 PM
checking that cells have a value before the workbook will close	kcdonaldson	Excel Worksheet Functions	8	December 5th 05 04:57 PM
Will excel add cells using colour coding eg Add all red cells	Wildwoody	Excel Discussion (Misc queries)	4	October 21st 05 01:02 AM
i want to use the =if function to apply a colour to other cells	pookie1970	Excel Worksheet Functions	1	June 20th 05 05:53 PM
Adding colour to a range of cells based on one of the cells v...	McKenna	Excel Discussion (Misc queries)	4	March 11th 05 02:25 PM

All times are GMT +1. The time now is 09:23 AM.

Menu

About Us