View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony96960 Anthony96960 is offline
external usenet poster
 
Posts: 2
Default conditional formatting a cell that has a formula

I have a list with a column (G) of answers ie (G3) =IMSUB(D3,F3) .etc
I am trying to colour code the answers ie <250 = green
250<500 = gold
500 = red

the conditional formatting seems to only reconise the formula and not the
answer in the cell
Please help

Regards Anthony