Thread: Conditional Formatting (If ab)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Conditional Formatting (If ab)
Select column A

FormatCFFormula is: =$A1$B1


Gord Dibben MS Excel MVP

On Mon, 3 Nov 2008 08:58:00 -0800, Hardeep_kanwar
wrote:

how can i make the cell red if a:ab:b by using Conditional formatting



A B
500 550
650 600
700 450
200 220
100 90
780 650
Thanks

hardeep kanwar

Reply With QuoteReply With Quote