='Current Adults'!F503
this is the formula i am currently using to get the data that i want off of another sheet. this will answer with whatever i type in the the block it is referencing,
well i type into the main block a date, but when i go back to my other sheet i don't want it to have a date there i just want it to show an X.
is there a way without changing the formula to tell a cell that if it is greater than 0 then it needs to display an X instead.
Again do not change the formula, this is a big list and i don't want to have to go cell by cell changing the formulas around.
Bookmarks