Hello All,
I am having trouble getting two conditional formats to work, see attachment.
First problem I am having is getting Row A14 through Q14 to color when A14 information greater than 0 is entered, I am trying to do rows A14 through A30 so any time information is entered that is greater then 0 that row will highlight. My current formula only highlights a few columns of that row (see attachment)
Second question is I have tried to have rows A14:Q30 appear a different color if no information (the Cell is blank) then change color with the above information is entered
Thanks in Advance, Jeff
Need Help Conditional format.xlsm
Bookmarks