tuckerpmission
New Member
- Joined
- Nov 24, 2015
- Messages
- 6
I am running productivity for my company and would like the productivity numbers to be conditionally formatted based on the values in the cells I am formatting, in addition to value in a second cell. Basically, we have 3 types of employees: Full Time, Part Time, and Per Visit, which would be listed in column A in this example. Their productivity numbers will be in column B.
Below is the criteria I need:
Full timers - green if corresponding productivity in column B is 5+, yellow if between 4-5, and red if below 4. Part timers green if 4+, yellow if between 3-4, and red if below 3. Per visits will be identical to the full timers for the time being, but I could see this changing so would still want a separate formula if necessary.
I created an IF formula in conditional formatting for one specific cell (i.e. =IF($A$2="FULL TIME",$B$2>5) and set format to green fill. The problem is when I pull it down throughout the spreadsheet, it will not adapt to the new cell numbers (i.e. should move to A3/B3 and so on). I also tried with removing the $ signs. This is starting to drive me nuts and I am really overthinking it.
Thx for the help!
Below is the criteria I need:
Full timers - green if corresponding productivity in column B is 5+, yellow if between 4-5, and red if below 4. Part timers green if 4+, yellow if between 3-4, and red if below 3. Per visits will be identical to the full timers for the time being, but I could see this changing so would still want a separate formula if necessary.
I created an IF formula in conditional formatting for one specific cell (i.e. =IF($A$2="FULL TIME",$B$2>5) and set format to green fill. The problem is when I pull it down throughout the spreadsheet, it will not adapt to the new cell numbers (i.e. should move to A3/B3 and so on). I also tried with removing the $ signs. This is starting to drive me nuts and I am really overthinking it.
Thx for the help!