Auto moving cell info with condition from sheet 1 to sheet 2.

[Liverlee]

Hi peeps.

Can i ask for your assistance again.

i need a formula for sheet 2 to extract info from sheet 1.

In sheet 1 of my workbook i have a annual leave planner. Dates run from column f5 to nf5. Several rows below are the stats running from f20 to nf20.

If the stat is higher than 3 (3 is in cell h20) i'd like to auto populate just the date i.e (h5 = 3rd jan jan 2019) into sheet 2 column b.

I haven't the foggiest of how to do this.

Please can some kind soul help me out.

 

[DSCfromCFA]

G'day there,

A bit more information is needed to give a definitve answer, however:
this formula in Sheet2 B# could work

=IF(Sheet1!H20>3,Sheet1!H5,"")

Which simply asks if the Sheet 1 cell H20 is greater than 3, and if it is copy the contents of Sheet 1 cell H5 into wherever this formula sits, or make it blank.

shane

 

[Liverlee]

G'day there,

A bit more information is needed to give a definitve answer, however:
this formula in Sheet2 B# could work

=IF(Sheet1!H20>3,Sheet1!H5,"")

Which simply asks if the Sheet 1 cell H20 is greater than 3, and if it is copy the contents of Sheet 1 cell H5 into wherever this formula sits, or make it blank.

shane

Thanks.

This is the file https://mega.nz/#!tkwFHK4B!8A8wxVL9S9_ABKQlvdLOIA6Xlorogk9ae2nbW0X-kyg

On sheet 2 I want to highlight, in red, any dates from sheet 1 that are greater than 3.