Using conditional formatting, you'll need to start by formatting one row.
Select the row. (Row 1 for this example)
Format -> Conditional formatting
Condition 1 -> Formula is -> =A4=Paid
(it's A4 because you're on row A and Column 4 (D) is the one you're testing)
Click Format.. and select...
Thanks for both these posts.
Tony, would you give me a pointer to setting up a palette please....
Thanks!
Steve
"...it's just me, putting my hand on my heart
Is it possible to use code to restrict the colours a user can choose for font / cell bg within Excel...?
A client wants to allow only corporate colours in a workbook.
If impossible, any thoughts welcome.
Steve
"And all of this is not imagination
Is it possible to use code (or without using code) to restrict the colours a user can choose within Excel...?
A client wants to allow only corporate colours in a workbook.
Steve
"And all of this is not imagination
Thanks for your lightning-fast response. Apologies for not being clear!
1 FormField Textboxes
2 To get text entered into the boxes after a button press
3 The idea is to for a Word doc to consist of a series of text boxes, similar to a questionaire. The end user will take this document and...
I'd like to refer to a number of textboxes from within a module (There may be 20 or 30 so I can't pass as parameters).
Any ideas as to syntax?
Thanks!
Steve
"In the Jungle of the Senses
I need to write some code to save the current Autofilter state, then clear all filters, then do some stuff I've already written, then, finally restore the original autofilter state.
All help appreciated!
Steve
"In the Jungle of the Senses
Holy Cow, that was fast!
yando's solution works well; Discord's seems to work well also, although I haven't tested it fully yet.
Thousands of thanks!
Love,
Steve
"Tinkerbell, and Jack the Ripper"
This is what I want...!
User clicks on an image link, a pop up window opens with a bigger version of the image. So far, so simple! The problem I'm having is passing a variable to the function to define the size of the opened window.
The code I've got is this;
<SCRIPT language=JavaScript>...
Thx TulsaJeff and OldNewbie.... it's working fine now. I love Netscape 4.79 and I love Flash and I love you!!
Love,
Steve
I'm ready, that's that, that's final, it's a wrap
You win, come on, drive me to the bar
I really appreciate your help Oldnewbie!
Testing this in Netscape 4.08. Flash variables are strdivision and stradd1 and the values I'm trying to get into Flash are Division (into strdivision) and 22 The Glades (into stradd1)
Love,
Steve
Take me to the river
Hey everybody, thanks for your feedback... I laughed I cried (but mostly I've been crying)
Our posts crossed (kind of like ships in the night...)
I've tried Old's suggestion now... putting swLiveConnect=true in a few different locations... no joy.
Any other ideas welcome...
Seriously I...
First post to this forum... Hi everybody... !
I've got a Flash movie in an HTML page... I'm passing variables to the movie and it works fine in IE but Netscape refuses to load the variables... Any ideas...?
Relevant code is below;
<object...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.