Thread: Conditional formatting based on numerical values of adjacent cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default Conditional formatting based on numerical values of adjacent cells
Use CF in A1 with a formula of =B10

--
__________________________________
HTH

Bob

"Rardel K" wrote in message
...
I am working on a form where cell A1 is text and I would like to use
conditional formatting to highlight A1, when B1 (number) is greater than
zero. I have not been able to figure this out and I would appreciate any
assistance.
--
Rardel


Reply With QuoteReply With Quote