Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying conditional formating
The conditional formating requires a boolean (true or false) to be returned.
Your expression returns a number. You really want something like this COUNTIF($A4:$G4,"Y")=1 enter the conditional formating in Format - Conditional Format and change "Cell Value is" to "formula is". enter your formula in the 1st box and sleect the Pattern (color). Because the columns are always going to be A - G put a dollar sign in front of the Column Letters. To copy conditional formating you need to use PasteSpecial with format selected. Put the conditional formating in one cell then copy and use PasteSpecial in the other cells. "Paul" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying conditional formating
Highlight the cells A8:G8, then click on Format | Conditional
Formatting. In the pop-up you should select Formula Is rather than Cell Value Is in the first box, and enter this formula: =$G8="Y" Then you can click on the Format button and if you want the background colour to be grey you need to click the Patterns tab and then choose grey. Click OK twice to exit the dialogue boxes. If you want to apply the same formatting to other rows, then highlight A8:G8 and double click the Format Painter icon. Then you can click on A9, A10, A11 etc in turn and the format will be applied. Press <Esc to cancel the Format Painter. Hope this helps. Pete On Jan 26, 11:57*am, Paul wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying conditional formating
I can't reconcile your formula with what you say you want to do.
If the condition for A8:G8 to be formatted is that G8=Y, the Formula Is condition would be =$G8="Y". -- David Biddulph "Paul" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying conditional formating
Thanks very much Pete. Sorted
"Pete_UK" wrote: Highlight the cells A8:G8, then click on Format | Conditional Formatting. In the pop-up you should select Formula Is rather than Cell Value Is in the first box, and enter this formula: =$G8="Y" Then you can click on the Format button and if you want the background colour to be grey you need to click the Patterns tab and then choose grey. Click OK twice to exit the dialogue boxes. If you want to apply the same formatting to other rows, then highlight A8:G8 and double click the Format Painter icon. Then you can click on A9, A10, A11 etc in turn and the format will be applied. Press <Esc to cancel the Format Painter. Hope this helps. Pete On Jan 26, 11:57 am, Paul wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying conditional formating
You're welcome, Paul - thanks for feeding back.
Pete On Jan 26, 2:02*pm, Paul wrote: Thanks very much Pete. Sorted |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating copying (Max Min) | Excel Worksheet Functions | |||
copying conditional formating | Excel Worksheet Functions | |||
copying conditional formating | Excel Discussion (Misc queries) | |||
Copying print formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) |