Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Excel VBA: Check each row for conditions. Help!

Hi

If the following conditions are met:

For any given row between row 10 and row 100 inclusively:

-The cell in column A is not empty; -The cell in column B is not empty; -The cell in column O is empty.

I would like to highlight a specific cell (let's say A1).

Example:

I populate A10 and E10 while leaving O10 empty, then cell A1 gets highlighted. If I then populate cell O10, the highlight in cell A1 disappears.

I can proceed to the next row. Any row at any time should generate these actions.

Thanks!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question to check the conditions and then print the result. Neelakanta New Users to Excel 1 June 18th 08 08:15 AM
2 conditions needed to check and count of items based on that Vijay Excel Worksheet Functions 2 May 3rd 07 10:21 PM
formula to check multiple conditions belvy123 Excel Discussion (Misc queries) 9 April 6th 07 10:00 AM
How to check for 1 of 4 conditions...Help Please jgbadingerjr Excel Discussion (Misc queries) 6 March 23rd 07 10:03 PM
How do I check the conditions of 2 fields to return a result Jimbob Excel Discussion (Misc queries) 3 January 17th 05 11:59 AM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"