Hi,
I have a sheet with data in Columns D to O & P starting from row 12. I want to conditionally format each row for columns D to O with a Green-Yellow-Red colour scale if the value of Column P (same row) is 1, else if the value is zero, no conditional formatting should be applied. I want each row formatted individually & I want the macro to recognise when it has reach the bottom of the sheet (column P will be blank at row 156) and stop running.
It's probably a language-thing but what's a "Green-Yellow-Red colour scale" ??
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
An option within Conditional Formatting/Color Scales
Capture2.JPG
I know how to apply the conditionally formatting.
I don't know how to write code for Excel to conditionally select Range D12:O12 based on P12, then do the same for rows 13 to 155
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks