Forum Discussion
Conditional Formatting for different cell values each row
Select the range that you want to format (E3:NE8).
I will assume that E3 is the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND(E$2>=$C3,E$2<=$D3)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
HansVogelaar- The cell is as shown in the picture.
The cells are blank, when I enter the dates To and From - it will display it with the colour and mention a text as "AL"
Enter the following formula in E3:
=IF(AND(E$2>=$C3,E$2<=$D3),"AL","")
Fill or copy down, then to the right.
I tried it out, but it doesnt work.
I inserted the earlier one and the new one as two different formulas and still doesnt work.
Could you attach a sample workbook without sensitive information? Thanks in advance.