excel training course - Conditional formatting based on the values in a different range

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.