Search for TRUE in spreadsheet

P

Paul

Is there a way to search for, and warp to, a cell that evaluates to
TRUE? or FALSE?
 
P

Pete_UK

Highlight a range of cells (or the whole sheet), then press F5 (GoTo).
Click on the Special button and then select Formulas, and de-select
Numbers etc to just leave Logicals. Then click OK.

Hope this helps.

Pete
 
P

Paul

Thanks, Pete.

Highlight a range of cells (or the whole sheet), then press F5 (GoTo).
Click on the Special button and then select Formulas, and de-select
Numbers etc to just leave Logicals. Then click OK.
Click to expand...
 
Top