Hi There
My last post was solved and now here is another issue.
I need to Conditional format Input Table Values as per fixed values of two multiple tables.
for example: one Table is for Input and the Other for Output (I and O)
now when i enter I in input table then it will search value from Input Table and match Value if it is A then the cell color will turn Red
if it is B then cell color will turn yellow.
and when i enter O in input table then it will search value from Output Table and match value if it is A then Red and if B then yellow.
there is another option if i enter "I/O" in input table then it well search from both tables input and out put and cell color will turn red if reference value is "A"
do i need to use "IF condition" or do i need to generate multiple function formula for both
as input table is getting values from two different tables.
Example file attached here: MyExample.xlsx
Bookmarks