Hi Forum,
I have a spreadsheet where I want to be able to Fill cells green in Column B to Column N for any Rows that have a value in Column L. All other Rows should remain the current colour (orange).
I can Fill the cells in Column L using conditional formatting but am not sure if I can use Conditional Formatting on other Columns so that their Fill colour is determined by the value in Column L?
Any suggestions?
Thanks very much
Dave
This is possible to do
Highlight the range you want (say, B2:N10), select CF and change "cell value is" to "formula is"
Does L contain a formula? If not, use this formula...
=$L2<>""
If has a formula and the answer is text, change it to...
=istext($L2)
If the answer will be numeric, change it to =isnumber($L2)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This works very well, thanks so much.
Dave
Happy to helpyou'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks