Thread: Referencing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Referencing

Is there a function that I can use in the conditional formatting that will
reference the cells in another column and return a yes answer if within a set
% limit?


More clarification: If A3 shows 5 and B3 shows 5.1, then A3 will be
highlighted. But if A3 shows 5 and B3 shows 10 then A3 will remain
unhighlighted.

I would like this to be done for each row.

Can this be done in conditional formatting?
--
Thank you!