formula on color
I wish to have cell B15 return the word "warning" if any cell in a table spaning from D18:I141 turns to a light red color (RGB: 230,185,184). Can a formula be set to recognize a specific color change? PS, the table cells will change to the light red color if a condition is met in that row. Regards, Gary
Last edited by allgeef; 03-25-2011 at 12:55 AM.
use the same formula you set the colour with to create the message
it would help if you provide the condition that sets the colour
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Martin, thanks for the suggestion. Regards, Gary
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks