hello,
I am trying like this.
1) If cell value is greater than 2 in any of the cell in column ZX, then i want entire row from A to L filled in Red color.
2) However, if user update the L column cell value to "Done", then it become unfilled.
Can we do it via conditional formatting?
Last edited by shiva_reshs; 09-04-2014 at 10:46 AM.
Keep the Forum clean :
1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Select A1
Conditional Formatting
New Rule
Use a formula to determine...
=(COUNTIF(ZX1:ZX100,">2")<>0)
format as red
Use Format painter (paintbrush icon) to copy to other cells
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks,,.,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks