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
|