View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Conditional formatting help needed

Select columns A:AO
FormatConditional Formatting...Formula is:
=a1=max(a:a)
Set the format you want
OK out.

Regards,
Fred.

"TGV" wrote in message
...
Hi

I am having numerical data from A1 to AO (A1:AO) like that the data is
available for 1500 rows. Now I want to Highlight the Maximum Value which
is
present in every rows (A:AO). Whether it is possible in conditional
formatting? If so, please guide me how I can do it.

Thank in advance.

TGV