So let's say I want to have cell b2 from my third sheet change if cell a1 from my first sheet has a certain value (let's just say 1 for simplicity.) What would be the formula for that?
Hi,
Something like this in the "Formula is", so that if A1 is greater than 10 then it is TRUE
=Sheet1!A1>10
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
I got an error message that said "You may not make references to other worksheets or workbooks for conditional formatting." Am I doing something wrong?Originally Posted by oldchippy
Also how to I add a hyperlink button to a website like google?
Hi,
Sorry my mistake, what you need to do is use a named range
http://www.homeandlearn.co.uk/me/mes9p2.html
Then use that in your Conditional Formatting formula
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks