Is there a way to have an IF formula look at colour and calculate according to that?
For example if a cell has Black text colour then it works one way, but if I manually change the text to Red then it changes?
Thanks!
Is there a way to have an IF formula look at colour and calculate according to that?
For example if a cell has Black text colour then it works one way, but if I manually change the text to Red then it changes?
Thanks!
Formulas cant read cell format colours, you need VBA for that.
However if your text is set by Condtional Formatting then just use the same conditions.
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.
Colour isn't data so changing the colour won't cause a recalculation. You can use a UDF to return a value/flag/whatever to indicate a change but, again, it won't work in real time ... only when you make a change that causes a recalculation.
You could look at SUBTOTAL and maybe use filters to hide/unhide rows. But that won't change automatically, you'd need to update the filter.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks