Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: formating Thanks again Lz. I am using =COUNTIF('EVM Work Order'!$J$13:$U$13,"<>") in my application and it works great. What would be the proper condition for any value greater than 0 in the range selected? Re: formatingI found what you did in the Conditional format menu selection Thanks againRe: formating Lorenzo Thank you so much. I'm having trouble seeing the actual formula used to change the color. Is it something like +IF(range) contains value, then background color + red? Thanks again D formating I would like to set the background color of a cell based on the numerical content of a range of cells in a different sheet of my workbook. Specifically, I want a cell to change color if any cell is a range of cells on another sheet has a value in it. Thanks Solved
