View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] chiuinggum@hotmail.com is offline
external usenet poster
 
Posts: 5
Default condition formatting involving formula

if cell is A1=100

how do i set a conditional formating for the following

1) if cell B1 value is greater than A1 by 20% fill blue
2) if cell B1 value is lower than A1 by 10% fill red
3) if cell B1 value is between condition (1) & (2) fill yellow