Strange problem here, would love some help!
basically, i have a very large sheet
Rows are employees
Columns are weeks
Each cell has a formula like
=IF(AND(Hours!F10>0,NOT($E10="p")),IF($E10="a",Hours!F10*Rates!$C$3,"")+IF($E10="b",Hours!F10*Rates!$C$4,"")+IF($E10="c",Hours!F10*Rates!$C$5,"")+IF($E10="d",Hours!F10*Rates!$C$6,"")+IF($E10="e",Hours!F10*Rates!$C$7,"")+IF($E10="f",Hours!F10*Rates!$C$8,"")+IF($E10="g",Hours!F10*Rates!$C$9,"")+IF($E10="h",Hours!F10*Rates!$C$10,"")+IF($E10="i",Rates!$C$11,"")+IF($E10="j",Rates!$C$12,""),"")
Which looks at the employee pay grade, how many hours they've been budgetted for, and comes back with the employee cost for that week.
This bit works fine.
What i can't figure out is, how to set up Conditional Formatting using this information.
What i've implemented on the Hours sheet is
If cell value is > 0, then colour the cell
BUT
For some reason, i can't do a
IF(Certain cell which contains the above formula>0, then colour the cell)
Even in an empty cell, whenever i just do a
IF(Certain cell which contains the above formula>0,TRUE,FALSE)
It ALWAYS comes up with True
Even if the formula result is a blank
I've done IF functions on formula results before, but this one just doesn't like it.
Even
If(Certain cell which contains the above formula>99999999999,TRUE,FALSE)
It still comes up as True!
Any advice would be great
Thank you!
basically, i have a very large sheet
Rows are employees
Columns are weeks
Each cell has a formula like
=IF(AND(Hours!F10>0,NOT($E10="p")),IF($E10="a",Hours!F10*Rates!$C$3,"")+IF($E10="b",Hours!F10*Rates!$C$4,"")+IF($E10="c",Hours!F10*Rates!$C$5,"")+IF($E10="d",Hours!F10*Rates!$C$6,"")+IF($E10="e",Hours!F10*Rates!$C$7,"")+IF($E10="f",Hours!F10*Rates!$C$8,"")+IF($E10="g",Hours!F10*Rates!$C$9,"")+IF($E10="h",Hours!F10*Rates!$C$10,"")+IF($E10="i",Rates!$C$11,"")+IF($E10="j",Rates!$C$12,""),"")
Which looks at the employee pay grade, how many hours they've been budgetted for, and comes back with the employee cost for that week.
This bit works fine.
What i can't figure out is, how to set up Conditional Formatting using this information.
What i've implemented on the Hours sheet is
If cell value is > 0, then colour the cell
BUT
For some reason, i can't do a
IF(Certain cell which contains the above formula>0, then colour the cell)
Even in an empty cell, whenever i just do a
IF(Certain cell which contains the above formula>0,TRUE,FALSE)
It ALWAYS comes up with True
Even if the formula result is a blank
I've done IF functions on formula results before, but this one just doesn't like it.
Even
If(Certain cell which contains the above formula>99999999999,TRUE,FALSE)
It still comes up as True!
Any advice would be great
Thank you!
