I need help. Im trying to write some formulas for a forecasting model and ideally what i need is.
Conditional format = various rules to change colour (i can do)
I then need to have another cell to look the the conditional formatted cell and have the following - IF Cell(x) = colour (a) then formula = xxxxxxxxx or if cell (x) = colour (b) then formula = yyyyyyy. Is there any way of doing this in excel
Hi,
Since you already have the rules for the colour formatting and use those self same rules in your formula, e.g.
IF(A1='formula for A1 colour format', 'this formula',IF(A1=.....etc
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Chip Pearson has an article here > http://www.cpearson.com/Excel/CFColors.htm about this however I know this hasnt always been successful.
Is it not easier just to replicate the CF conditions in an IF statement?
If someone has helped you then please add to their Reputation
excel formulas cannot see formatting, only data, and CF is formatting, so....
No, not with a regular formula. You can possibly use the same CF rules you already have for that,IF Cell(x) = colour (a) then formula = xxxxxxxxx or if cell (x) = colour (b) then formula = yyyyyyy. Is there any way of doing this in excel
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks