Conditional formatting
Hi everybody first time here,hope you can all understand what I am asking? Here go's
If cell k2 has a formula in it which is basically (cell h2-i2 ) can cell k2 also have a conditional format in it, which is instigated by cell d2.Hope some one out there can help? I think I need to use a macro but I am not sure.
Conditional formatting works against the cell's own value OR with formulas to look at other cell's. Both are doable.
You can try it either way, or post a sample and show us what you want to happen and we can help.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks