Posted to microsoft.public.excel.misc

Paul

external usenet poster

Posts: 661

Copying conditional formating

Hi All,

I need to copy the folowwing conditional fromat into my spreadsheet

Formula Is =COUNTIF(A4:G4,"Y")

I want to copy this so if G8= Y cells A8:G8 go grey etc
I have set the format but it wont copy. I have been paying around with the
$ sign but still no joy

My head hurts please help

VMT Paul

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
Conditional Formating copying (Max Min)	Excelicious	Excel Worksheet Functions	3	April 3rd 08 06:47 PM
copying conditional formating	Alpal	Excel Worksheet Functions	1	September 28th 07 06:02 PM
copying conditional formating	Jorge	Excel Discussion (Misc queries)	8	March 29th 07 01:41 PM
Copying print formating	jd	Excel Discussion (Misc queries)	4	February 7th 07 04:22 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM

All times are GMT +1. The time now is 02:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us