LinkBack URL
About LinkBacks
Hi
In my worksheet i would like to apply conditional formatting to column F only if it has a value and also if the value in column G is less than or equal to zero.
Any help please.
Hi
In my worksheet i would like to apply conditional formatting to column F only if it has a value and also if the value in column G is less than or equal to zero.
Any help please.
Hi,
Presumably with the following formula in F1 using the 'Use a formula' option, and applying to your whole column F range.
=AND(F1<>"",G1<=0)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Book1.xlsm
Hi
That's what I thought but it doesn't highlight anything. I will attach the sheet. In row 620 it should highlight cell F but it doesn't!!!
Hi,
If you go back to the conditional format rule and examine what's in the box you'll see
="AND(F5<>"""",G5<=0)"
instead of
=AND(F5<>"""",G5<=0)
i.e. there are literal quotes around the formula. Remove them and you'll be OK.
Re: CONDITIONAL FORMATtING
Thanks it works now. If I have a macro that runs this worksheet can I add the conditional formatting to it and how and where would I do it.
Terri
Hi
Perhaps the following at the start of the macro, although it may not make a difference where you add it. All depends what the rest of the macro is doing.
Change the range F1:F10 as appropriate
Please Login or Register to view this content.
Hi
The range is not a consistent number of rows is there a way around this?
Terri
Bump. Anyone with an answer to this?
Untested but you can try this
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I tried to add this to my macro and it does not highlight what it should.
You are already working on this part in this thread http://www.excelforum.com/excel-prog...ponding-2.html right?
Yes this one here worked great as I used it as a once off so I can close this thread. I am continuously needing help in the other thread and you can see where I used this in that thread it worked. The others didn't sadly.Originally Posted by arlu1201
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks