View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DHEvans333 DHEvans333 is offline
external usenet poster
 
Posts: 1
Default Conditional Formatting Formula

I'm trying to conditionally format a rows of cells in comparison to a set row
of cells. That is, if A31.25*O3 or if O31.25*A3 format the value of A3 red
and bold. Then, if B31.25*O3 or if O31.25*B3 do the same, and on and on.
It's comparing monthly figures to year averages. I've tried several methods
and haven't had any luck! Any body know the secret? Thanks!
--
David Harmon Evans