Hi all

Is it possible to use conditional formatting on (e.g.) one column, based on the values in a different column? How would one go about this?

For example, I wish to highlight a staff member's name (column 1) based on their date of entry (column 2).

Thanks in advance for any assistance.

Yuri

Hi Yuri. It certainly is possible to do this. Format the cells in column 2 so that the date appears as a number (Format - Cells - Number Tab - Number option) and make a note of the number value you want: for example 09/06/1973 resolves to 26824

Then select the cell column 1 you want to format conditionally. Select Format - Conditional Formatting and change "Cell Value Is" to "Formula is" and enter the formula =$B$1>26824. Select what formatting options you want to appear conditionally in Column 1 and click OK.

If you now reformat column 2 back to the Date format the result will be when you enter a date greater than 09/06/73, the cell in column 1 will turn, say, red. Enter a date less than 09/06/73 and the cell will stay the same. In this way you can distinguish cell data on the basis of dates in another column.

Thank you Anthony, that definitely answered my query! So basically make a reference to the cell range you want to check in the 'formula is' condition.