View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Conditional Formatting?

Excel2003 ... To turn pattern of every other row ... I am using conditional
format formula ... =mod(row(),2)=1

to change Font RED for any Cell Value ending in "P/T" ... I am using
conditional format formula ... Right(Cell,3)="P/T".

Above said ... I would like to write conditional format formula that will do
both at the same time ... Alternate Cell Pattern for every other row & Font
Pattern RED for any Cell Value ending in "P/T".

Thanks ... Kha