Thank you ahead of time if you can help me with this. I have information in column 12 that has conditional formatting that turns the text read if certain requirments are not met. I've been trying to write code that goes thru column 12 to see which are in red and then returns the information in column 1 if column 12 is red. I seem to be stuck with no success so any help would be much appreciated
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Priting a certain cell out to the screen
- Thread starter seasmith
- Start date
Jerry Sullivan
MrExcel MVP
- Joined
- Mar 18, 2010
- Messages
- 8,787
I don't think that there is a Range property that directly identifies the "currently displayed" color appearance of a cell when that color appearance might be coming from a Conditional Formatting (CF) rule being TRUE.
If you know the CF rule for a cell that will make it appear "Red", a quick and easy way to test if the cell is red is just to have VBA or worksheet formula do it's own test to see if the CF rule should evaluate TRUE for that cell.
If your code needs to be more general purpose, you'll need to go through the FormatConditions associated with that cell or range.
If you know the CF rule for a cell that will make it appear "Red", a quick and easy way to test if the cell is red is just to have VBA or worksheet formula do it's own test to see if the CF rule should evaluate TRUE for that cell.
If your code needs to be more general purpose, you'll need to go through the FormatConditions associated with that cell or range.
Upvote
0
Similar threads
- Question
- Question
- Question
