How do i conditional format a row with reference from column?

**radicrains** · 02-06-2012, 11:20 PM

Hi,

I'm trying to create this spreadsheet that helps me to identify the employee that works OT for the particular month, & colour format is the cell value is > 0.
I understand that we can manually colour the cells ourselves, but it makes no sense for me to do it manually if my company has over 300ppl..

Attached is an extraction of the spreadsheet that I'm building up..
The "Employee(End Prod)" tab is the desired end product of the format that i wanted in case my explanation is confusing..

Thanks in adv!

**radicrains** · 02-07-2012, 02:23 AM

Hi again guys,

Its alright, my colleague & i have manage to solve the situation..

All i needed to do was go to conditional formatting>select "formula is"

=IF(AND($E5="Overtime",F4>0),1,0)

Set the format of the cell if the condition is true.

OK.

Copy & Paste Special it to the entire workbook..
Attached is the solution..

Enjoy!