IF cell =such color then text report
Solved
Gwweenn
Posted messages
18
Status
Membre
-
commentcamarcheeay Posted messages 735 Status Membre -
commentcamarcheeay Posted messages 735 Status Membre -
Hello everyone,
I have a formula that is posing a problem, which seemed manageable at first glance!!!
Maybe you can help me.
So I have an Excel table on a sheet named 'tracking table' that has several columns: last name, first name, address, granted amount.....
Once I have finished processing their files, I color those cells (it doesn’t matter, for example green) and then I move those cells to another table (sheet allocation table)
So what I would like is that IF('tracking table'!C3:G3 is green then ='tracking table'!C3:G3)
I hope this is clear enough, otherwise I will share my file
Thanks :)
I have a formula that is posing a problem, which seemed manageable at first glance!!!
Maybe you can help me.
So I have an Excel table on a sheet named 'tracking table' that has several columns: last name, first name, address, granted amount.....
Once I have finished processing their files, I color those cells (it doesn’t matter, for example green) and then I move those cells to another table (sheet allocation table)
So what I would like is that IF('tracking table'!C3:G3 is green then ='tracking table'!C3:G3)
I hope this is clear enough, otherwise I will share my file
Thanks :)
5 réponses
Hello,
I advise you not to use color as a verification criterion. Colors are a visual representation, not variables (even though it is possible to use them as conditional variables). Therefore, you can add a second column (which you can hide later) that marks the cells that meet your condition.
If you absolutely want to use colors as a criterion, it's less clean, but it's possible. You will need to use macros in this case. It will look something like this:
Then put this function in a cell that will convert the color into a value
--
C. Taha
I advise you not to use color as a verification criterion. Colors are a visual representation, not variables (even though it is possible to use them as conditional variables). Therefore, you can add a second column (which you can hide later) that marks the cells that meet your condition.
If you absolutely want to use colors as a criterion, it's less clean, but it's possible. You will need to use macros in this case. It will look something like this:
Public Function myColor(myCell as Range) myColor = myCell.Interior.Color End Function
Then put this function in a cell that will convert the color into a value
=myColor(A1). You can base your criterion on this value.
--
C. Taha
