View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
TGV TGV is offline
external usenet poster
 
Posts: 63
Default Conditional formatting help needed

Thanks for your suggestions, but both of the answers are not resolved my
issue. Please go through my post once again I want to highlight each rows
maximum value. Anyone pls help me.

Thank you,

TGV


"Fred Smith" wrote:

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