Request search tab

[fady77]

DEAR ALL
I WOULD APPRECIATE IF YOU COULD HELP TO CREATE A SEARCH TAB SIMILAR TO ctrl+find THAT CAN SEARCH ANY CELL VALUE PLACED IN A SEARCH BOX OR CELL
ALSO I WOULD LIKE TO CREATE A COLOUR ACTIVE CELL ONLY WITHOUT ROW OR COLUMN WITHOUT LOSING THE PREVIOUS COLORED CELLS OR CELLS COLORED BY THE CONDITIONAL FORMATING
PLEASE FEEL FREE TO CREATE THE REQUESTED ON THE ATTACHED FILE

THANK YOU

[AliGW]

Firstly, please edit your post to sentence case - ALL CAPITALS are very hard to read!

Secondly, we don't work to a brief and build solutions for you, so please tell us what you have tried to do to solve your two issues and in what way what you have done is not working.

[fady77]

thank you for your quick reply
sorry for the caps
first I would like to create a search tab to function the same as when you open the (CTRL+FIND) window I tried to create a vba action but I did not find the right fraction
second I tried to highlight the active cell but I lost all the previous highlighted cells and I could not use the conditional formating i already created
thank you for your help I did not mean to anyone that u do the job for me
regards

[AliGW]

OK - so where in the workbook should we be looking? Where are the active and previously highlighted cells? Where have you mocked up what you want to achieve?

This is a bit like a treasure hunt without any clues ...

[fady77]

OK - so where in the workbook should we be looking? Where are the active and previously highlighted cells? Where have you mocked up what you want to achieve?

This is a bit like a treasure hunt without any clues ...

OK i will try to explain as much as i can by detailes
If u notice in sheet the highlighted cells are changed by entering any data and in the finishing date column the date changed to red if the value of the date is < than
today() and if you notice the green highlighted cells these are changed according to a formating that the value is >than today() +2
If i want to create a highlighted active cell all the conditional formating and the regular highlighted cells are disapiring
Regarding the creation of a tab search i was trying to create it from vba but i couldn't find the correct formula for it because i don't want to open the find window every time i want to find specific cell value

I hope this explanation is fine
And I am sorry for my low knowledge in excel i appreciate your help with this matter