Hi
I have an excel file in which i have just used the basic formula "=today()-E7", in N7 which gives me the number of days passed from the date in E7.
I have given conditional formatting to N7 that minimum midpoint maximum , turning the cell to red at maximum point.
Now, in another cell H7 i will be putting the text " Price Given".
Once I enter that text "Price Given" into H7, I need the cell N7 to change color to Green.
How can I get this done ?
I tried conditional formatting specific text; but it is not working.
Maybe because there is already one formula there ?
Please advise !
Thank You
Bookmarks