Forum Discussion
Conditional Formatting based on cell contents and location
Select L49:Z49.
L49 should be the active cell in the selected range.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'greater than' from the second drop down.
In the box next to it, enter the formula=L48
(Important: no $ sign before the column letter L!)
Click Format...
Activate the Fill tab.
Select red as fill color.
Click OK, then click OK again.
Select L49:Z49.
L49 should be the active cell in the selected range.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'greater than' from the second drop down.
In the box next to it, enter the formula
=L48
(Important: no $ sign before the column letter L!)
Click Format...
Activate the Fill tab.
Select red as fill color.
Click OK, then click OK again.
Thanks, Hans. I didn't have a chance to delete my post but I already figured out that I needed the $ in front of the row and it would all work. I knew it was something so simple. I really appreciate your time.